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

timed header image rotation
I have a joomla site and I was trying to setup a rotating image based on timing NOT just refreshing

Solution Manager BPR
Does the SolMan-BPR-ARIS-Integration (http://www.ids-scheer.com/en/ARIS/ARIS_Platform/ARIS_Business_

how to transport the Query and insfoset
Hi

I have created the query using SQ01........
How to created T-code for query..

parsing error
can anyone explain this syntax error:

Parse error: syntax error, unexpected T_IF

The e

Windows 7
Windows 7 default user account control worries experts. Corporate IT departments should be pleased w

Sort Alternative/bi-monthly
Hi all,

Am going mad trying to get something to work.

I'm creating a CMS for a magazi

Reditecting pages based on logic
Newbie here, apologies in advance!

I am trying to use the header function to forward one of a

Remote Database Access
Hey guys!!

OK, i'm used to only working with databases from the CPANEL, accessing phpMyAdmin

Can anyone give me some link on .htaccess tutorial
i wish to have friendly url using .htaccess, but no idea yet about this

Hope that anyone cou

problem with refreshing
in my site, i have an index page, it has a main div. this main div's content is changing according t