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

Showing selected item at top of list
Hi,

I've got a list of names which i am fetching from database like this:
$qry = db_query

Inserting a check in checkbox from array value
Hello all,
I have a bit of code that works for a select option box, but does not work for my chec

insert Multiple rows into the table from that table data
Hi All,

I have a requirement like to insert mulitple rows into the table from that

Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

download directory onto C drive
I am attempting (if this is possible) to write a routine to automatically dump the contents of a dir

Staff Induction System - No idea where to go from here!!!
Hi there, I'm pretty new to PHP and Mysql so could really do with being pointed in the right directi

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde

start new row of pictures
on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get

Can you help please? Php file
I have to write this php file to allow users to register their nicknames on nickserv

For an I

data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t