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

Checking if multidimensional array is empty?
I have a for with multiple test input fields. Specifically the user submits multiple names and ages

Need help with basic sql
Hi,

I am using oracle 10g, and having some small doubts related to sql , here goes the si

Confusing Functions
So, I've been reading up on Functions and I like them! However, I need some help using variables in

Pagination won't carry results past page 2.
Hi all,

I've worked out my pagination script and its paginating fine until I click next from

The IE or FF detector
Hello Friends,

Problem of today ( we seek for php help ) as following ,

we know all th

Mass activity scheduling
Hi experts,

Im facing some problems to deal with mass activity jobs.
When I run some

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba

output printing as hexadecmal... XD
Everything works except the calcem call for the totusold and totuprice. The out put shows up as hex.

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

big pagination problem in php
<?php

$connect = mysql_connect("localhost", "root", "")

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