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

Weird MySQL error, why am I recieving this?
PHP Code:


<?php require "global_settings.php"; ?>
<titl

session_destroy();
new to php
I have a simple login and am trying to write a logout.
I set a $_SESSION var to 1 i

Problem with PHP code- simple contact form
Hi Folks,
I'm relativily new to PHP; I know HTML and CSS stuff but I have a problem- I have a co

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

Points for Wiki contribution
Hi everyone,

I want to know how long does it take for the moderator to award points for a

How to assign JS screen.width to ASP.Net variable
I've got this ASP.net routine that gets the cookie value of the screen width, but now I need to chan

noob cURL help
I have a pretty basic form that I need to cURL post to a file in my includes folder (includes/login.

Else statement screws up all css
Does anyone know what goes wrong in the process with this php code?
This code seems to be causing

Error in query: Resource id #4??
hey guys, having a minor (i think) problem here that i havent been able to figure out. long story sh

Syntax error
hi im having a little trobble with this script
-------------------------------------------------