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

Include a php
Hello,

I'm trying to include a function that shows the recent searches.
Example I have <

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

Can php detect connection speed and thereafter swap out elements?
No code to post, lads, yet. Just looking for a yay or nay at this stage:

Can a php script be

onclick problem
I have <input type="text" name="message">
<a href=page2.

How to extract/download content from HTTPS page?
Hello to all the Members of this forum, Im Shoiab, A novice programmer in php.. for my first job I h

Developing Ajax-enabled ASP.Net applications for the iPhone
I would like to develop Ajax web applications using Visual Studio that are optimized for the iPhone.

Day of week
I am using PHP version 5.0.5
I have a varaible ($DATE (date format yyyy-mm-dd)) that is being inc

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

PHP Error
On my .php page I have a drop down box that has several names in it. When a user clicks the name &am

Setting condidtions for an input box
Hi all,

I would like to set a condition in a txt box that says the number a user enters has t