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

duplicate record notification
In my database, after insertion of records, I want to know if the record inserted is duplicate or no

pointer 102 question
I read a book
1
2
3
4
5
6
7
8
9
10
11
12
int main() {

multiple recipients + dbuser mail recall
Hello,

I am building a php login script.

When the user registers the script will send

MII Netweaver Server stopped due to CPIC connection Problem
Dear Experts,
We have SAP XMII 12.0 setup running on Netweaver 2004s,7.0, Java Stack only.

Ajax Issues - Update Panel / Timer. Intellisense doesn't know about them
Type 'System.Web.UI.ScriptManager' does not have a public property named 'UpdatePanel'. That is wha

help removing unwanted graphic
How do I remove the small elongated rectangular shape between the "Latest post" and "

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

Problem related to Creation of PDF File?
Hi All,
I am facing a problem related to creation pdf file. when I am creating a pdf file of do

Simple image grab script.
I was wondering if it was possible and if anyone knew how to make a simple php script that looks at

server trace logs
could any one tell me from where do i get error logs in xMII??I want to check the reason for dtabase