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.

Did you know?Explore Trending and Topic pages for more stories like this.
Now, how can i find his records which are active in the dates between '01-JAN-2007' AND '01-JAN-2008'

Thanks
No comments posted yet

Your Answer:

Login to answer
243 Like 17 Dislike
Previous forums Next forums
Other forums

Must be a string? Huh, what? HELP?
with the following script, I get
Fatal error: Property name must be a string in /home/content/e/

SAP Logon Failed
I tried to login to SAP through MMC.

When i click start and give password.

it

PHP mail() rejected by SMTP
I'm currently working on a newsletter application which is installed on a windows 2003 server runnin

Applet JTextField Size Problem
Hello,

I recently started making an applet to calculate certain values for airplanes. However

asking for direction
I have 2 tables in my data, which are "post" and "event"
I won't make a summa

Firewall / visited websites logger
Hi. I have a firewall implementation and I want to log all the websites visited on the machine. S

DB2 for z/OS, LUW, iSeries
Hello, In this forum a lot of threads related to other members of the DB2 family than DB2 for z/OS

Passing an array of values From VB6.0 to Oracle PL/SQL Function
Basically we are using VB6.0.

When we try to pass an array from VB6.0 to an Oracle PL/SQL

Unable to customise toolbar in FCK
Parse error: syntax error, unexpected $end in
hello,
i receive the error :Parse error: syntax error, unexpected $end in C:xamppxampphtdocsh

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash