Format (Time) ??

[omarswan]

Hi,
I was playing around with the format function,

Format(now, "Short Time")

Inoticed that it always returns the time in a 24hr format. How can I format the time and display it in a 12hr format?

example:
I want 1:30
instead of 13:30

[André]

Hi there, use this:

Format("13:30:02", "h:mm a/p")

You will get 1:30 p,

Good luck,
André

[André]

Of course it should be:
Format(Now,"h:mm a/p")

André