Time & date 'on print'

[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

 

[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

 

[Jock W]

That's sorted it. Brilliant.
Easy when u know how!

Thanks,