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

calculator
I can't figure out why this code doesn't work. No error messages. Page loads.

Code: <

Last character removed
I have created a string from an array. I have inserted commas from my form values. I am trying to re

php unable to sent email
Hi, guys, I try to send a email through php but unfortunately the mail unable to sent. Here is my co

Undefined Index Notice In Internet Explorer Only
I am getting the following notice:

QuoteNotice: Undefined index: jrox in /home/ycsn/public_h

need help in mysql_num_rows()
please tell me what i am doing wrong in this query. it displays this error

Code: Warning: mys

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

default SAP userid
hi,, I just like to know if it is ok to use the default SAP user id (SAP*)?

Menu restriction
How can I restrict the individual menu that would appear when a user logs in so that all users are c

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include