records between 2 dates

Posted on 16th Feb 2014 07:03 pm by admin

Hello all,

I have a date tracked table which contains effective_start_date and effective_end_date fields where we have the start date and end dates of an employee. Each employee can have multiple records with different start and end date.

Now, how can i find his records which are active in the dates between '01-JAN-2007' AND '01-JAN-2008'

Thanks

Your Answer:

Login to answer

Other forums

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario

php include email form with attachment
I have had no luck with finding a email form all over the Internet for various reasons. Some insecur

error reporting
hey everyone

I have a production server in which I want error reporting but only on some page

SAP Project Module
I have seen in the SAP Project Module,plan cost and budget are not equal and even difference is sign

Help with usergroups? prolly really quick
So were coding our own forums for a game system we made an we have the users level setup but now I n

Help With editting and deleting form
Hallo !!

So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.pn

problems with script
I made a small script wich exchanges points in my website:


<?php
session_start

PHP4 to PHP5 Conversion
Hi Everyone,

I am working on a site that is built up on PHP4 and each page is being started f

What exactly is net neatrality?
What exactly is it? I think it's anti-censorship and... stuff... but I don't really understand it

Odd or Even
Inside of a while loop I need to echo several rows of info...easy enough.

In the loop (for th