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

Reading waves
Hi,

I am trying to find a way of finding the highs and lows on a graph line, the line points

PHP header help!
Hi all I am trying to get this php page to refresh every 5 seconds on my phone which is an aastra 48

Target costs on Process orders not calculating
Hi All,

We have released standard costs for all the materials. We have also done Goods r

IIS7 and getimagesize() problem
I have just discovered after hrs of trying to fix a problem where it's coming from. It's to do with

How to Detect it is public_html or httpdocs?
How to check whether it is cPanel or Plesk?

If it found public_html perform <?php incl

passing an array of objects after submit
How do I do this? This is what I have tried and it is not working.

<form method="

php web service error
hey guys,
I'm working on a project requires the use of web services. I've been trying a few tutor

At max how many columns is advisable to create in a table/view
Hi All,
I have two transaction table from which i want to create a simple view or material

'grab_files', multiple extension?
hey guys,

can anyone suggest a way to make to following line of code look for files with more

Members Only
Hi all, for my website i have a members area only which on members can veiw, but at the moment anyon