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

Php script to read msword file
hi,

I need to read a msword file and i want to print the contents in that word file.

i

Displaying data from MySql a different way
Hi all,
I'm pretty new to php and MySql and have hit a problem.

I am able to display data

problems with php variables in mysql query
i can't seem to get the following query to work.

select $q1c from $vote_rate where id = $re

help with contest script
I would like to code a contest script to my site but i don't know how. Could someone just give me pu

PHP loop
Okay so I have several "articles" stored in a mysql database and am attempting to echo tho

Javascript using window.location seems to lose state
Not sure what forum so let me know if I'm in the wrong place. I have a main window with a ajax grid

Insert Failing.
Hey,
I am making a Sign up page for a website, but the insert query into the Database does not se

Display data returned from Ajaxservices!!
I have a question about displaying results using ajax. I have part of the code below.
$.ajax({

if else problem, help please
i have this script that i made only i try to also put in a if else for for some reason the script is

[Need Help] php timing issues
I don't know what is going wrong. I need some help with being able to set an image at 9:00am Colorad