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

$_POST variable un-useable
I'm trying to use a $_POST variable in a mysql update statement but i can't use it for some unknown

Variable passed to each() is not an array or object
Hi,

This is a email a friend type of form, and it isn't working anymore.

<?

controlling/creating accounts with privileges
hi all,
i'm trying to figure out how i can create/control account with privileges, for instance a

Changing files over
Just thought I'd start with the new forums looking really nice .

Ok basically I've made this

C++ API to Oracle dB
I need to perform a select command to the Oracle dB to obtain information from a table.
What libr

IMAGE - SERVER SIDE scripting help...
How to receive pixel data of an image and buid a bitmap file on the server using the HTTP POST metho

Two warning messages
Quote<b>Warning</b>: mysql_real_escape_string() expects parameter 1 to

Using loop to count number of entries
I'm writing a program that must ask user to type in numbers. After each entry, the program has to re

TimeZoneOffset
Hello,

Please i need your help. I have a system that users can use to punch in and out. This

mySQL and PHP search
Hello,
I am trying to code a project and ran into a brick wall with one of my pages. I am pretty