Hi
I have a table that contains information that has start dates and end
dates. They are stored in short date format.
I have built a web page that initially returned all the information. I
then want to return information spcific to todays date, where I used
dim todDate
todDate = now
then I did
shTodDate = FormatDateTime(todDate, 2)
which returned the date to a web page that was in the same format as
what was in the access table.
SELECT * from Events WHERE stDate = # ' & shTodDate & ' #;"
This was fine beacuse it returned all events that started on that day.
This doesn't help though because some events last a few days, so I
tried the following
SELECT * FROM Events WHERE stDate >=#'&shTodDate&'# AND
endDate<=#'&shTodDate&'#;
This still only returned events that started on the current day.
Does anyone know how I can use <= or >= when comparing dates?
Thanks
puREp3s+