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

Multiple while loops
I have several DB queries that I know should be returning results and aren't. I have a feeling it ha

Showing selected item at top of list
Hi,

I've got a list of names which i am fetching from database like this:
$qry = db_query

Add_Months not Easy to Understand
Oracle is number 1, very fast and very easy. But....
OK, I think but have a problem, only 1 pro

Hit counter updating once per IP - IP HIT COUNTER
I have a hit counter, for the amount of views on a tutorial.
It'll do the query and then do..

Delete all from a table
I can not get the following code to work. If I run the sql statement in the db it will delete all t

mail() says sent but no email received
My code is quite simple:

Code: <?php
$to = "Ty44ler@yahoo.com";
$subje

Session problem?!?
Hello All! I am very new to the php world but I am working on fixing things that a previous programm

IDOC error
Hi, When i send IDOC from ECC system to MII there is no problem ECC side, i says message sent succe

form problem
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for

Call Screen statement Error
Dear Experts,

is there any setting that needs to be done before creating any dialog progr