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

Bluetooth RSSI & VIsta
Okie I got 4 Bluetooth adapters, a DBT-120 by Dlink, A Zonet Microsoft Bluetooth which is what I use

retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell

Email with Attachments in PHP
Hi Friends

How to send email in PHP with attachment.
I know simple mail can be sent with

array empty
Hiya peeps,

Ok here is the codes.

order.php

Code:

Word filter problem
Hello,

im trying to make a filter for words inputted in to my website but i want to store the

Ball movement
I want to move a ball from one point to another and it should hit a group of balls at the other end

Internal Server Error issues
This has been bothering me for weeks and I've been trying to solve it without asking for help, but e

UDS 4.0 Datatype issue
UDS 4.0.322 -- connecting to NI Labview 9.0

When using connection method: Cache with live

duplicate record notification
In my database, after insertion of records, I want to know if the record inserted is duplicate or no

LOOPing Problem
Hello All!

The following code loops through the data and displays the data accordingly. My p