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 kill asynchronous postback / current postback?
Hi,here is my problem:I have a web site with many pages of which some may take time to process resul

Email Form Syantax Issue 2
How to make this look FROM:"OUR TEAM" instead of FROM:abc@mail.com

$headers = "

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

The control with ID 'ace' requires a ScriptManager on the page
I'm trying to add a simple AlwaysVisibleControlExtender to my page, but it's not working. I get the

Delete all from a table
I can not get the following code to work. If I run the sql statement in the db it will delete all t

Uploading Filetypes and placing them in seperate folders.
Hello,

first post , and asking for help im afraid. Very new to PHP, was making good progress

difference between datetimes
($row['totime']-$row['fromtime'])/60

this is giving me 0

example of totime and fromtim

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.

Stuck with preg_replace
Hi,

I'm trying to use preg_replace to remove part of the IP address submitted using a form on

update the selected existing records of database
Hi frndz,
I am new to php and get stuck....

Edit.php > Update.php > Updatea