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

Get word number x from string?
How can I use a function to loop through a string, and "have a look at" every word in the

Filtering Tables
Hello Thanks for any help any one can give Im very new to PHP..

I need to pull data for clien

Help with echo()
I'm having some problems with this code:

Code: echo '
<A HREF="jav

Warning: mysql_num_rows() expects parameter 1
When i add quote at the end of this link
example:http://localhost/articlemania/category.php?cid=3

Error Messaging not working
I changed the way my form tells the user of an error. But I can't seem to get it to work properly.

sapgui f4 help last search
I know this has to be simople. One user (maybe more) does not have the "last search saved" from the

script is pulling more then they have....
I have this script for my game where they can change there race. This will cost them 2,500 points. H

PHP MySQL Return Results Issue
Hi guys,

I'm running joomla and made a module which is using ajax.
Basically i just have a

natcasesort works on one server but not on another
Hi

I have a problem that I was hoping that someone can help me with.

I'm trying to use

Which PHP-Editor do you think is the best?
Hi everyone,
Myself Brian Anderson. For the last 2 years i have been working a