Time & date 'on print'

J

Jock W

Using =Format(Date(),"dddd"", ""mmm d yyyy") I have the day and date printed
on a form when it's printed.
How do I modify this slightly to show the print time as well?

tia
 
R

Rob Parker

Change Date() to Now(), and add your desired time format string. For
example,
=Format(Now(),"dddd"", ""mmm d yyyy hh:nn")
gives me
Thursday, Oct 26 2006 18:32

See Help for Format Property - Date/Time Data Type for a full listing of the
possibilities for the formats available.

HTH,

Rob
 
Top