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

Transferring session variables into MySQL
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statem

User information
Hi All,
By using t-code SUIM we get all the user details,if suppose we donot have permission t

Form validation with functions
Hi there

I am trying to make a very simple form validation function. I currently have the fol

Problem with umlauts and UTF-8
Hello every1,

I'm creating my own little CMS at the moment and got some problems with the cha

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

Page doesn't expand for content
Hi. I've been testing a query I made. It's here http://lapr1.6te.net/inquerito.php
The page doesn

Transport data between itab and textfield on ALV event
Hallo,

I have a ALV Grid ( cl_gui_alv_grid ) and I also have hotspot click event with a h

Multiple WHILE loops help
Hi there. I'm writing an application that is pulling and displaying results for real estate listing

why aint this working?
i have this code:

Code: $num = 250;
$count = ($num - $rcount);

echo $rc

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th