asp syntax for criteria

[nn]

Hi

I want to display results for items in a database when a field names date is
later than today's date.

What do I need to set for the value in criteria to do this??

Thanks

Mike

 

[Jim Buyens]

-----Original Message-----

Hi
Howdy.

I want to display results for items in a database when a
field names date is later than today's date.

What do I need to set for the value in criteria to do
this??

For Access, try this in a custom query.

SELECT * FROM myTable WHERE ([date] >= Date()+1);

For anything else, you may need to check the database
documentation and replace Date() with a different
expression that returns the current date, excluding any
fractional part for time.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

 

[Kathleen Anderson [MVP - FP]]

http://www.spiderwebwoman.com/tutorials/working_with_dates.htm