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

session checking in page load
hai all I have a web site is www.Mryas.com in this my login page is Page1.aspx its co

Material Issuing for receiving batch
Dear All experts in MM/ PP,

Material issuing from main stores to factory is currently usi

Online Event Ticket Sales
Has anyone wrote a script for online tickets sales?

I have been googling and found lots of th

ctype() validation - allowing illegal characters
Hello,
I use ctype() to filter and validate a user form. However, I am trying to allow certain c

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

Add trigger to UpdatePanel programmatically
Hi,I'm working on a website which uses AJAX and Masterpages. What I have is an AJAX UpdatePanel whi

void* and sizeof()
Hi,

Using void* and sizeof is it possible to get the value of the object ?

I understan

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario

Why does my php page download images over and over
Can anybody please explain to me why my php page keeps downloading the images and other items every