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.

Did you know?Explore Trending and Topic pages for more stories like this.
Now, how can i find his records which are active in the dates between '01-JAN-2007' AND '01-JAN-2008'

Thanks
No comments posted yet

Your Answer:

Login to answer
243 Like 17 Dislike
Previous forums Next forums
Other forums

Multidimensional $_POST
Hello

How to get a single array from array of array (2 - dimension).
For example I have a

Output Full URL of Current Page
Let's say I am currently viewing a dynamic page:

http://www.mydomain.com/directory/index.php

Attempt to assign property of non-object in...
I'm having issues with the following function in PHP 5...

function getTreeWithChildre

Feed Maker
Hi all.
First of all I must say I am not a php developer so I am afraid I don't know much about i

Error in SQL Syntax HELP!!!
I have this page:

Code: <?php

session_start();

//connect to server and s

Form validation with functions
Hi there

I am trying to make a very simple form validation function. I currently have the fol

PHP error (line 38) my website
Hello everyone, I'm new on this
and I got a web site thats got a error not showing the photos on<

cstdatomic (c++0x std::atomic) / g++ 4.4
Hello,

I'm trying to use cstdatomic (std::atomic in the upcoming c++0x standard) in g++

Extract specific information from a PHP Multidimensional Array
Howdy! I've racked my brain over this for 24 hours now. I think it's time I asked for help. I'm lear

Finding digits in variable containing text, and IDing them
$romanstock = "http://www.remoteprice.com/data.asp?storeid=123&itemcode=456&typ

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash