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

switch form actions? not working
i want on submit to go to different pages according to the CatID

Code: <?php $CatID=$_

Does deleting the spmlog directory critical?
Hi Everyone,

Please, hope you could help me. We're having problems with the SAP backup. I

Session is not saving
I am not trying to do anything too fancy, I am just trying to get some $_SESSION data to save and us

http to https
Hi,

Is there any specific method/condition to move an http:// page to https:// ?

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

Captcha problem users just refresh and it will let them auto submit again
Users will just re submit and not have to enter the new captcha.. ? Lol but if i refresh the page, t

Namespace Problem
I'm having problem with a section of code with a variable namespace.

This code works fine:

Rss feed question
Hi

My blog and my website are different. Am i able to take my rss feed
from my blog and p

TimeZoneOffset
Hello,

Please i need your help. I have a system that users can use to punch in and out. This

Need help in Generating Combinations
Need help generating all possible combination of names in an array

Lets say i have the follow