|
anupalavila
Yak Posting Veteran
54 Posts |
 Posted - 12/02/2008 : 04:23:53
|
I have a table with 3 fields Id,datafrom and dateTo how can I know the Id of a given date which falls between datefrom and dateTo for the date
Id datefrom dateTo
1 2008-11-1 00:00:00.000 2008-11-3 00:00:00.000
2 2008-11-5 00:00:00.000 2008-11-7 00:00:00.000
3 2008-11-9 00:00:00.000 2008-11-11 00:00:00.000
if I enter date as 2008-11-10 00:00:00.000 I could get the Id 3
Thanks and Regards
Anu Palavila |
Edited by - anupalavila on 12/02/2008 04:34:38
|
|
select Id for a date
