getting only the date with the Now function

[genevx]

Hi,

How do you get only the date with use of the NOW function and not with the time also? thanks

 

[ColinEssex]

Date()

 

[Nero]

You can use the Now function just make sure that your field is set to short date format.
But the Date() format is preferred

 

[Pat Hartman]

Format only affects how data is displayed. It does not change how it is stored. Date() is the function to use when you don't want to store the time. Of course you could always use Format(Now(),"Short Date") - but what's the point.

 

[genevx]

heh...thanks guys...greatly appreciate it!