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

Linkage between two scripts
Okay say I have this for a link in a script:

Code: <li><a href="#&q

Why use OOP?
Can someone explain to me why I should use OOP instead of procedure based code.

Im building a

EXplanation help
Hey all,

I am still fairly new to PHP programming and I am trying to put together a page wher

How to display objects in a row
I have 7 codes that i want to display in a row one next to another.
The first is {$ads->ad

To change the name of label on SAP screen XK02.
Hi All,

Can one suggest me how to change the label of an input field of a sap standard s

HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen

show the direct link into href
I want to display link on the page. i am fetching the data(URL) from database,actually before that i

Please help - should be a simple fix.. driving me nuts
Everything seemed to be working fine. I have a table, it alphabetically lists a bunch of cities and

Can we convert non uni code system into unicode
Hi All,

Presently i am using non-unicode system and the sap version is 4.7.
Can i c

matching numbers inside ( )
I know I can match numbers by just [0-9]+, so I thought matching numbers inside ( ) would be somethi