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

problem with query error
First Thanks to those who helped me on my previous posts, and the following code i'm using is not mi

How To Make More Than One Redirection with PHP on the same page?
Hey im trying to do a direction page where it open differently link direction pages every time som

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

Material xxx does not exist in plant xxx
Dear All,

I am working for a steel project which is repetitive manufacturing.

background color imagefill
Hello

I would like to ask you why I see this square in red color just in my local xampp insta

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is

MySQL-PHP Query Results Help
Hello all. I'm hoping to be able to get some help in solving a problem with query/rowcount output. I

More pug propaganda.
http://www.youtube.com/watch?v=8Kkrmubsgf8

The commercial is definitely worth watching pug aw

division gives infinity anser
int main()
{
int z=0;
int i=1/z;
cout<
}

It doesn't throw a

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s

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