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

remove trailing slash from array
I have the following array which contains trailing slashes I need to remove. What is the best way to

PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

need good snippet manager
Hi. as i am coding and learning more, it is becoming difficult to manage code snippets. how you mana

change text color with a jQuery code
Hihow can I change the text in a asp:TextBox to a different color when I start typing using jQuery?I

Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the

need help with php get
i have a option box that gets filled with dates, but how do i get once the option value has been cli

Help with Contact Form
I have this Form on an html page and the associated code on page.php (below).
I keep getting the

Check before inserting in DB ???
This is my code
---------------
if ( $_POST ['Submit'])
{{
$username = $_POST ['usernm

Setting a default timezone?
I have read about how to change the timezone in PHPMYADMIN, but it changes back, it doesn't STAY the

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