Dates

[EscapeUK]

In my DB the format is datetime (oracle)

Where I only want the user to enter the date. Howvere I want to compare the date entered by the user with the current date (using Now). But now brings back the date and time so it does not work properly. How can I only bring back the date.

 

[sdh]

Format(Now, "short date&quot

will return just date in short format
etc
so set a variable holding that info and use that in the calculation
:

 

[MatsHulten]

Or the Date() function would work to...

-Mats Hulten