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

When i am Canseling the Billing Document in VF11 I am getting Shortdump
Hi Experts

When i am Canseling the Billing Document in VF11 I am getting Shortdump.

str_replace help
I am thinking str_replace is my only option to filter outputs from my database to convert them to sa

Passing Variables
What I'm wanting to do is when the user clicks on Arenas it will know the name of the country it's w

UDP Multicast question
Hey,

Im not really in the know when it comes to network related programming and activitie

Relative path
I have a absolute path to an image - like so: C:/Program Files/Apache Software Foundation/Apache2.2/

Return X values where an ID number doesnt matter
Well as for subject heading, thats the best i could think of.

Currently im having a problem w

Help with usergroups? prolly really quick
So were coding our own forums for a game system we made an we have the users level setup but now I n

How would I convert this into code using an if statement?
ES equals exam score m equals $mean s equals $total. I already coded my mean and total so I'm not g

sql problems
I am having a small problem with my sql statement. it is inserting into 4 of the fields.

fie

Bar charts using Graphical Framework.
I am using Graphical Frameworks(GFW) to create a chart Graphic . There is no problem with the data d