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

Help, Base64 encoding url and decoding server side.
Hello everyone, i have a website with videos and games and also provide an embed code which people c

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

array_diff weirdness
I'm using the following bit of code

$diff = array_diff($pids, $pidlist);
$diff = array_va

How to store checkbox array in a session, and then be able to add to it?
I'm trying to store an array of checkbox values into a session array, sort of like a shopping cart,

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

Strange Oracle Query problem
Ok So I have this PHP class that talks to a Javascript class that basically creates a table of infor

Is there something wrong?
Hi all,

Just a quick question... can someone look at this code and see if something is wrong?

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

printing links
Hi every1

i am connecting to a table in sql and the looping through with a while ($ var = my