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

Setting/Modify Headers using mail() function
I have a question about setting email headers when using mail() in a php script.

When I send

how to use two buttons with php
hi i have one form. there are three fields which are to be filled by the user. and then there are tw

$_GET problem
Hi all,

Have a bit of a problem with a little piece of code, I am not sure if this should be

PHP Captcha Error help - replace the "die" command
Hi All,

I am after a bit of help with a Captcha spam protection box.

The site gave me

Windows 7
Windows 7 default user account control worries experts. Corporate IT departments should be pleased w

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

JSON SORT WITH PHP
I have two products that I want to sort by say "Id:17, value: xxx" using php
The page w

Multidimensional array problems in $_POST
I'm having trouble with a three-dimensional $_POST array. It starts as a two-dimensional array on th

PHP IMAGE UPLOAD SCRIPT
Hi for the last week i have been looking for scripts that will upload a photo to a certain folder wh

BI in Upstream Production operations
Appreciate if you can assist in the following areas:
1) Examples of life before and after BI i