How do I select a date range in a FP 2003 DB results page?

[Craig M]

I have the custom query set but cannot get if to compare the dates in the
database to the current system date.

e.g.
Select * FROM results WHERE database_date > date()

Please help, I only want to show records where the dates are current.

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Craig:
See if this helps:
http://www.spiderwebwoman.com/tutorials/working_with_todays_date.htm