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

why does my session end?
my connect.php starts the session just so you know
i can navigate arround my site fine except whe

selectbox+database connection retrive problem
Code: [Select]
<tr>
<th align="left" scope="c

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

$variable = $variable
Hello

Sorry if this is a really simple question but I have run out of ideas. Is there a reall

Simple AND question
Hello,

I've got following code:

Code: if(strpos($row[13],"http://")

SQL Query/echo not working
Hey all,

I'm trying to run (what I thought) was a simple operation and it isn't working. I h

Parse String
I need to parse the string below into three variables. How would I do that?

john + 10/20/2008

Something like an INI editor or a DelimitedText-Editor
Hi all,

Am very, very, very new to PHP and not sure if I should be posting this to a Javascri

DATEDIFF Question
First time post, and of course it is a help question.

I am using a WP plug-in to display prev

Variable Clash
In the past I've had variables clash. For example:

Code: <?php
$c = 5;
$ca