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

elseif help!
OK so I'm new to the site, as well as PHP altogether (Trying my hand at managing an online RPG) and

Class not found error
I am getting Class 'index' not found in Eval function:

//write config

$pat

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the

Why is my row count 0?
Here's the MySQL query i'm running. It basically pulls data from 2 tables based on some data passed.

Stopping page post back
I have few literal contriols in my page and a repeater too. But inspite of using update panel, postb

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d

ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128
Hi all,

Oracle 10g. Linux.

I'm facing the below error while trying to import a dumpfil

how can i expire the submitted page using session.
hi,
i'm new to php world.
i'm using "post" method.
when i submit it,data goes to

Table colours fail when extra row added
Hey Gurus,

I got a weird problem with formating the colour of a table made in php. Everything

help with this code please?
Hello,

I am trying to build a remote upload script for my image hosting site.

I am usi