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

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

with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

Any help with my email script?
I have an email script, I have not tested it, although someone tested it for me and said it worked f

Help with parsing this html
Hi,
I've got some html i just need a couple of strings from.. argh, it's freaking me out. I've t

Parse XML
Good day,

I use oempro software and try to parse XMLReturn but it's not working for me, simpl

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

PHP code needed to get/post form fields and request mysql query results.
I'm new to PHP

I've created an html form to allow the user to request a basic telephone dire

Redirect not working after making a POST/GET
Hi Everyone,

I am a novice in PHP. Here I have 2 pages, one page with a textbox and button an

Module pool selction screen parameters combination logic
Hi floks,
Am new to the module pool development ,Recently i have created one program based on