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

phpMailer not working ..........
HI,
I was playing with the phpMailer script and tried to send a smiple mail using their test scri

help with Get_
ok some how this is not working i am not sure what i am doing wrong here but what this does is when

Small problem with image resize script
Hi!

I am a little bit new to php and I have an issue installing an image resize script I down

Reditecting pages based on logic
Newbie here, apologies in advance!

I am trying to use the header function to forward one of a

How to Create a Dynamic table
col1 col2 date1 date2 date3 date4..........
a b v1 v2 v3 v4

Beginner question regarding Array's
Hi everyone, the page im working on has an array of variable at the top...

Code: $define_li

dynamic table with forms
I have a table that is populated with mysql data and in teh first column there is a raido button tha

Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as

single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be

xml element exists
Code: [Select]<?xml version="1.0"?>
<Addresses>
<