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

building a function with multiple outputs
I want to build a function that has multiple outputs.

I know but am not to sure how I should

18ct rullade guld sötnos armband
[b][url=http://sv.linkslondonbracelet.net/]Länkar i London grossist[/url][/b][b]Länkar i Lond

Luxueux Montblanc Marlene Dietrich ont été en forte demande depuis longtemps
[b][url=http://www.pensclub.cn/fr/]stylos[/url][/b] [b][url=http://www.pensclub.cn/fr/]stylos mont b

Hermes Bolide Laukut, Hermes Bolide 37cm
[b][url=http://fi.luxuryhermes.top/]Hermes myytävänä[/url][/b] [b][url=http://www.luxuryher

Vestidos de casamento loja online, barato do desenhador vestidos de noiva festa, vestidos especiais da ocasião&acessórios para venda
Comprar vestidos de noiva
Comprar vestidos de noiva
[b]Wedding Tomada Vestido Fábrica[/b]