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

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

order by date not ID number help php
I am trying to orginize the following code to order by date not id number.
any help would be grea

Calling All PHPFREAKS Blackberry Users
Are you a member of PHPFreaks and have a blackberry? Well RIM just recently released Blackberry Mes

Time script, set to my time zone?
I am using this line to get the date and time

Code: $time = date(F." ".d.", &q

this code is strange !
Hi i got this code from the web.. It checks for live and dead socks
It is working perfectly on my

Send current URL in URL with a $_GET variable problem.
Hello community,

I have created a function that gets the current variable of a page, example:

PHP Script runs on CLI but not through web browser
I am running into an issue that I just can't seem to find the answer to. I have a Windows Server 200

IDOC error
Hi, When i send IDOC from ECC system to MII there is no problem ECC side, i says message sent succe

SWF image using php?
Hello once again.

My latest en devour requires me to produce an image of a static .swf that i

Having Problem with Date
l have a submit buttom where user have the possibility to add a date to specify when his message s