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

Auto-populating dropdowns and multiple forms.
Here's what I have so far:

First drop down = select a state (works)
This populates the sec

this code is not working????
it says this error.. Warning: Division by zero in ..

the variables are correct, so why is th

mail() problem
Hi Guys,

I've set up a contact email form. It sends the information fine, but it sends it to

GIS appliction help
I found some tutorials in the internet to develop a map application I don't want to use google maps

Registration
ok so i have a site where people can register and login which works now thanks to someone on here th

Parse Error Help
Hello, I got the parse error "Parse error: syntax error, unexpected ',' in register.php on line

Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system

Say I go to h

Trouble verifying database password
Thankyou to everyone who responded to my last post (I can't find the posting, it has been buried). <

MVC - Code review
I'm in the process of trying to wrap my head around MVC, and as part of that, I'm attempting to impl

Load Animated Image while cache is serve
I have a page that loads up using cache and took about 1 to 2 minutes before it loads to the page. <

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