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

IP question
ive got 2 ip addresses both global from same user how would i detect if they are local to each other

CHECH A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a

Login Script Issues
I am using a script I got from http://phpsense.com/php/php-login-script.html in order to allow peopl

Is it possible to view php source code??
Hi All

I was just wondering if it's possible to view a websites php source code?
I know

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

Reading Most Recent CSV File in Directory
I thought I had wrapped this project up, but found out that the program I use to FTP a csv file to m

Multiple arrays inside data
Hi,

Simple question. I have a column called "array" in my database, and inserted in

Help With Showing Users On the Index Page
Ive got this code which works just how i want it to.

Code: <?
$timenow=time();

EXplanation help
Hey all,

I am still fairly new to PHP programming and I am trying to put together a page wher

Warning: session_start() headers already sent error - Driving me Nuts!
I am trying my sister in laws site and I keep getting an error with my coding. I am more of a design