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

Finding digits in variable containing text, and IDing them
$romanstock = "http://www.remoteprice.com/data.asp?storeid=123&itemcode=456&typ

Newb advice
Hi all,

I'm a flash front end designer and I've taken on a project that needs some back end p

retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell

defining website tags
Hi,

What would be the best way to define tags for my site, such as website title, url etc.

Cloud Computing?
Hello,

I was wondering if anyone could help explain this term to me. I'm starting to hear it

subtract 1 from value entered in text field
Hi

How do I subtract 1 from the vaue entered into a text field?

Thanks

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba

MS are the best!!!
Visit http://www.microsoft.com/australia/windows/default.aspx?h=watch-a-demo and click the massive '

Not Inserting into DB
I can't get my Add new Division form to submit to the database. Anyone see my issue?

Code: &a

unserialize help, getting errors
hi all ,
I got a form with 6 fields (2 input and 4 select box), when the page loads one block is