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

how can i make a .gif images for my site
Dear Friends ,

Pls solve my problem , I am starting making new site but i dont know how can i

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

Track downloads' status
Hello,

I need to make somehow, some system, to track whether downloads are completed or faile

mysql_query returning boolean instead of mysql ressource
Hi,

I seem to have a weird issue with the php command mysql_query. I pass 2 arguments the que

random generation
hi

i need help with generating this

numbers from 1-12

i want to generate in ran

Multiple Options for a Single Page
For this example I want to use the Handlers option which is under Fed Admin and all the related codi

gmmktime or mktime
I live in the UK, i am within the GMT (with daylight saving time ie 1 hour difrence between summer a

Echoing a Variable from a Object
How do I get a variable from the new User Class to echo out in this clasS?

class MyApp
{

mails going in spam??
The mails I sent to folks in my database using mail(function) are going in spam??

Any idea ho

Cant display mysql data
Hey all,

I am learning php and my first goal is to create a simple CMS. At the moment I am st