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

This must be easy , pulling the last record of the day, every day, from a txt
I have a txt file logging weather data every minutes (so 1 record per minute). I want to extract the

Time-based image rotation script
I'm trying to write a PHP script that rotates an image based on what time of day it is. I want the

Calling strings from other php class
I have test1.php{
$string1;
$string2;
....
... //10 strings in this class <

Validation
Hello

I know this is a really vag question.

I need to have a input field on a form th

Dynamic Array using glob?
Is there an easier way to do this?

I am trying to get create a dyamic array based on files wi

same querie, or a new one??
Hi guys,

I'm still working on this drop down list. I've got the actual drop down list to wor

array_map() probably obvious mistake
The code below is part of a class to escape strings, but should also accept an array, using array_ma

A little help in c#
i am doing a simple paint program using c# i want to draw with the mouse so i wrote the code of the

Curl & sessions PLS HELP
Hello,

I have a problem with curl and sessions and i will try to explain the best i could.

Paypal
Hi all,

I have an advanced basic knowledge of php

I want to try something new for a s