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

Creation of Raw Exposure manually
SAP Gurus

I am creating Raw Exposure ( Hedge management ) thru T Code TEM10 with followin

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

Xml parsing
I need a suggestion about parsing xml with multiply parts like pervious...
i.e. different device

What is SAP Avatar ?
Hi All,

This G.Satish , my boss asked me to explore on SAP Avatar. I searced in internet

Lack of simpleXML Documentation
What is up with this.

Look at: http://www.php.net/manual/en/function.simplexml-load-file.php<

How can I Compare two xml documents?
Hi all,

I am doing a POC for my project and I am using XE database 10g version.

iMatch stored value with the current value in a loop
Hello,

I have a MySQL db were I store articles in.

I have a form to fill these article

update sql when refresh - php
hi
I have made a table (attachement)

the users can update the sql database using + or x bu

Mail from PHP form not always ending up in my inbox?
Hi guys,

I'm a real newbie to PHP and have managed to put together a simple mail form that se