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

My XSRF Prevention code isn't working
First of all, thanks for the generous help you guys have given me in the past on this forum.
Seco

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav

Question about ShowWindow()
Hello....

I'm struggling with sumpin, and I hope y'all can help.

I've got a CFormView

JQuery, Masterpage, and Control issue
Hey everyone, I am using JQuery in several sites so I thought it would be best to place the library

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

losing session vars when arriving from an email link
Hi,

I've got a confirmation script made that sends an email with a link for a user to confirm

help with image text
Hi ...

see i need the text of the name and number to start in the center and always be in the

PHP page is blank
Hi Everyone,

I have a site in which I am able to open the first PHP webpage in my browser but