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

temporary objects
Until now i thought every temporary object in C++ is created as constant. I'm wondering why my compi

Simple program to copy files between two computers over the web
I use logmein free and often need to move files between my two computers. Generally, I move the file

Retrieving innerHTML with cURL?
Hey all (sorry I know I'm a leecher, but I soon won't be. This is my first PHP project, but not my l

Problem with shopcart code
Hello, I am having a bit of trouble being able to add a product to my shopcart. My mysql database i

chat
hello i'm amir i need a chat source code in asp.net 2.0 without Ajax. anybody can help me?

Schedule editor
Hi,

I have a question related to Schedule editor.
If we schedule a BLS for every 30

Please Help my PHP Dating Function.
Hi everyone!

Well here is my code that displays this:

It works wonderful.

$_FILES array
Ok,

I just started experimenting with PHP today. My goal right now is to have people be able

Can I use a loop
Hi buddies!

Once again with my doubts here.

Right now I am using this sql stat

Code working in IE but not FireFox
I created a dynamic navigation list for my website based off of a table in my database. The code is