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

Checkbox info wont include in Mailto
Hey, im new to php.
Basically I have made a form to request which type of job(s) are needed, whic

Blank record injected into database
I always found several blank records inside my database, although $SESSION is required to insert the

Linkage between two scripts
Okay say I have this for a link in a script:

Code: <li><a href="#&q

php mailer
How can i send a mail to large no, say 50,000 reciepients using [color=#0000FF]php mailer[/color]

PHP Blog help
Need help with posting comments in a word press blog? I have a comments page where the comments are

A rank users order by points
I want to make an insert from table 'rank' , with number (rank) from the cod blow, to fild users.ran

Check Date/Time in PHP
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h

Detail Expenses Report by Cost Center
I would like to obtain a report out of SAP that shows a list of expenses by cost center that shows t

Load Animated Image while cache is serve
I have a page that loads up using cache and took about 1 to 2 minutes before it loads to the page. <

Fetching array then reversing it
Hi, I have a simple problem, I'll try to explain it as best I can:
News entries in my database ar