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

How to show the difference between two data field in a database with php.
Hello php gurus,

how r u all... i'm not so well facing a typical problem please help me...<

trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an arra

Upload file!
Ok i have a form..
Code: <form name="form1" method="post" action=&quo

URL Rewrite issue
Im created a series of Rewrites and on page checks to make sure the correct url is being called. But

get font info from a font file
hello,

Does anyone know how to get font info from a font file ... using php of course !
<

Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo

php global variable
how can we create global variable so we can use its value in any form.. Please give example to

This must be easy , pulling the last record of the day, every day, from a txt
I have a txt file logging weather data every minutes (so 1 record per minute). I want to extract the

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi

Google voice
I currently have a form in html, but I want it in php so the information is not in the source code.<