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

Printing a webpage
I use this to print the webpage: o

Problem in back link
I have page where i have given javascript back link but when i click on it browser give a message

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

Unable to customise toolbar in FCK
My query is being run with no results.
I have this.

Code: function DropUser($duser_id, $user_email, $user_username) {

upload image name with extension using php
hi frds..

<input id="file1" type="file" name="file[]" &a

Warning: session_start() headers already sent error - Driving me Nuts!
I am trying my sister in laws site and I keep getting an error with my coding. I am more of a design

Agency Business Process
Hi,

I don’t understand the process of the agency business in SAP.

In my

Sorting JTable on more than just the values listed in the columns
I have a collection of objects that store (among other things) two integer values. I only want to di

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me