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

Get relative path from absolute path
How would one go about getting the relative path to a file from its absolute path?

insert mysql embeded videos as blobs?
Using TinyMCE my client will be able to embed images and flash videos into large columns of text whi

How to show next and prev records
Hi all,

Sorry if this is simple, i'm very new to php, well, any programming language actually

adding up might be solved tell us cheers.
i think i finally solved this anybody.

last time i was getting the wrong results.

Code

True way to see if action was successful?
If this is a good way to see if action was successful to continue:

Code: function changeGa

Removing Title From database problem
Hi again ! i am having an issue with updating database. When i update any price of a title it remove

Problem!
I have another problem, when i run this code i get this error "Parse error: syntax error, unexp

How to store checkbox array in a session, and then be able to add to it?
I'm trying to store an array of checkbox values into a session array, sort of like a shopping cart,

PHP search multiple input field box help
I am having a problem with my search script. At current it will simply search by a selected date whi

unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_
Can anyone view my code and tell me why im getting the error:
Parse error: syntax error, unexpect