esthera
07-08-2008, 05:00 AM
i have the following code
if datediff("s",formatdatetime(startdate,3),rscft("starttime"))<1 and datediff("s",formatdatetime(startdate,3),rscft("endtime"))>0 then
now if rscft("starttime") is say 1:00 and rscft("endtime") is 5:00 it works fine
my problem is if it extents the night
so if rscft("starttime")=19:00 and rscft("endtime")=7:00 it doesn't find the numbers between those times
(my goal is that if the time of startdate is within the starttime and endtime then
i execute the then code
if datediff("s",formatdatetime(startdate,3),rscft("starttime"))<1 and datediff("s",formatdatetime(startdate,3),rscft("endtime"))>0 then
now if rscft("starttime") is say 1:00 and rscft("endtime") is 5:00 it works fine
my problem is if it extents the night
so if rscft("starttime")=19:00 and rscft("endtime")=7:00 it doesn't find the numbers between those times
(my goal is that if the time of startdate is within the starttime and endtime then
i execute the then code