The Now() function

  • Thread starter Thread starter Guest
  • Start date Start date
If you want a different date format, simply nest the Now() function within a
format function.

Format(Now(), "mm/dd/yyyy")
 
Derek said:
Is there a way to return set the date format returned?
Click to expand...

The Now(), Date(), and Time() functions don't return any particular
format; they return the date/time value the way it is stored
internally. Whatever format you see is the result of that value being
formatted for display, either explicitly -- by the Format property of a
control or by calling the Format() function -- or implicitly, by Access
using the default date or time format as specified in the user's PC
settings.
 
Back
Top