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

Form validation with functions
Hi there

I am trying to make a very simple form validation function. I currently have the fol

Delete all files in folder except with certain name
I have a script that I want to delete all files in a folder (taken from a database) except for one n

Update Database
Hi All,


I have a problem with this:

Code: [Select]<?php
session_start();

1,000 select boxes with 100 options?!
I have 1 drop down select box with 1,000 options.


In some case, there will be 100+ of the

Need Help with a query
Hello,
For some reason I am just not getting the right answer when I do this query and not quite

losing variables between php brackets
Hi

have got this code:
Code: $id=mysql_result($result,0,"itemid");
$title=mys

Google voice
I currently have a form in html, but I want it in php so the information is not in the source code.<

Request for tunning the below query
Hi,

Can any one help me on the below query while improving the performance,

Get value from Select menu
Hi!

Have tried to find the solution on the web. Don't know if there is an easy one. A descrip

$_POST variable un-useable
I'm trying to use a $_POST variable in a mysql update statement but i can't use it for some unknown