help - now() returns long time. Need medium time.

M

Mike D.

When using the now() function, it sends back "MM/DD/YYYY
HH:MM:SS AM". I'm trying to get "MM/DD/YY HH:MM AM" to
show on the report. Any suggestions?

Thanks,
Mike D.
 
C

Cheryl Fischer

Try the Format() function, for example

Format(Now(),"mm/dd/yy hh:nn am/pm")
 
F

Fredg

Mike,
Set the Format property of the control to:
mm/dd/yy hh:nn AM/PM

Note the use of nn to represent minutes, not mm (which represents months).

For more about this formatting, place your cursor in the
control's Format property line and press F1.
Click on the Date/Time hyperlink.
 
Top