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

SAP FICO learning materials
Hi all,
I am new to this world of SAP FICO. I have taken training on SAP FICO, but was wonderin

Thought I has this figured out especially after all the help i received?
Cags, Salathe, Daniel helped me with this yesterday, but not sure i took it all in.
I am attempti

Is it possible to stop reservation creation in PM Order?
Hi All,

Is it possible to stop reservation creation in PM Order?

Thanks in adv

no idea what to do...
I'm fed up. I had issues with code that I have working on a different site that didn't work on my cu

Varible in trigger - refering to correct schema
Hello

Im having some issues with my trigger.
What I want to do is call opon a differ

Having a problem get the selected item from a drop down menu
I have been looking at this for days now.

I have a drop down menu that get it's values from a

Onclick problem in Firefox
Hi,
I am using a . It doesn't seem to

Problem with array max size.
Hi to everyone,
I've got a homework about filling a bidimensional array un spiral shape, I alre

why this query can delete duplicates ?
why this query can delete duplicates ? Anybody can give me the detailed explanation ?

Tha

Passing an array of values From VB6.0 to Oracle PL/SQL Function
Basically we are using VB6.0.

When we try to pass an array from VB6.0 to an Oracle PL/SQL