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

Show message after entering data
Hello Colleagues

I would like to display messages after entering the data example: "
dat

Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What

Security Exception on pages using AJAX
I am getting the exception: attempted to perform an operation not allowed by the security policy on

SAP Project Module
I have seen in the SAP Project Module,plan cost and budget are not equal and even difference is sign

Apple's revamped lineup arrives

I'm personally curious about the magic mouse.. a multi-touch concept sounds like it could be nea

Need help-Error istream header declaration
Hi Everyone ,

I am having issue with istream declaration. I am new to C programming.
can a

Can't find a decent web analytics!!!
I've downloaded and installed Piwik. It's location detection based on IP addresses is fairly inaccur

Gridview Not updating in Update Panel
I have a gridview, three dropdown list boxes, and a button on my form. What is displayed in the gri

FFmpeg Images 2 Video conversion problem ??
I got folder full of images , number of images = 600 , I want to make a video which plays one image

calendar dates and hours compare problem
i have a calendar in wordpress, everything works great except that i can make 2 meetings at the same