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

Simple PHP/Java Help..
Hi,
I'm trying to build a little program to do with calculating postage. Unfortunately i haven't

BB_Code error
I'm having a problem with a custom built function and keep getting this error:


Warning: M

Mass activity scheduling
Hi experts,

Im facing some problems to deal with mass activity jobs.
When I run some

Remove letter from numeric textbox
I have a textbox that will search the employee database by entering in the employee ID and it will r

Using insert variable
need a way to inert variable data to mysql database

$acc = "212121212";
$nok =

There was a problem with the request. (Code: 0)
Any Idea what could cause this? I get it randomly at best. But with both IE and FF. It derives from

Add a sign-up feature to a flat file login script
I'm working on a flat file login script and I would like to add a sign-up feature to it with a email

Php - mysql store data and use it later?
Hi, i' making a login page at the moment, however my username + password is stored many different pl

Echoing a Variable from a Object
How do I get a variable from the new User Class to echo out in this clasS?

class MyApp
{

Using Microsoft Exchange Server with PHP
Hi,

I wanted to know if its possible to fetch email attachments from the exchange server usin