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

Not capturing all the information we require in the form.......
Hi Guys,

I was wondering if you would share some more of your knowledge today, I'm hoping it

php slowing my site?
Hi all,

I think that one of the reasons that my site doesn't work fast is that the code is ve

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

getting a website's source code as a variable? How?
Hey guys, is there any way for me to get the source code of a website as a variable for me to work w

Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret

Allegro crashes when running load_bitmap. Why?
I can not get Allegro to load any BMP images. Here is a section of test code. The picture is in the

Empty text file when there is over XXXX lines of text.

define("RANDOM_FILE","/public_html/random.txt");
$randomEntry = "

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

PHP form authentication
Hi guys,

what am trying to achieve is this: Whenever a user tries to login to my website, an

ScriptManager History and Opera Issue
I am having an issue in opera with the ScriptManager. I have a ScriptManager on a page with history