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

Save User Inputs while javascript reloading!
hi..
i have written a PHP code in which i reload the page when user selects a value in dropdown..

SQL query not working well
Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum

PHP & Java
Hello,

can PHP code be used inside java code?

Code: <SCRIPT LANGUAGE="Java

Function module "DPS_CHECK_TABLE_EXISTS" not found (after OSS 1422843 impl)
Dear All,

I implemented Note OSS 1422843.

When i execute the new report RSPO20

Loop Through Date Range
Hi guys,
I have date range as parameter like 01/JAN/2009 TO 16/JAN/2009 now i want to loop thro

PHP/PKI
I am trying to set up a web application that uses pki. does anyone have a good tutorial to set this

gettext translates ALWAYS?
I'm using gettext with the new version of XAMPP (5.3.0) on Windows Seven RTM (build 7600)
gettext

php mail form text wont appear / javascript included
Guys/gals...

I am running into a problem whereby I have a great piece of javascript code that

word wrap in emails help needed
Hello, I understand how wordwrap works in php and have used it well before. However when I used wor

Search with relational database
Hey,

I have quite a complicated (for me anyway ) relational database for an apartments syste