Hi,
I was playing around with the format function,
Inoticed that it always returns the time in a 24hr format. How can I format the time and display it in a 12hr format?Code:Format(now, "Short Time")
example:
I want 1:30
instead of 13:30
Printable View
Hi,
I was playing around with the format function,
Inoticed that it always returns the time in a 24hr format. How can I format the time and display it in a 12hr format?Code:Format(now, "Short Time")
example:
I want 1:30
instead of 13:30
Hi there, use this:
Format("13:30:02", "h:mm a/p")
You will get 1:30 p,
Good luck,
André
Of course it should be:
Format(Now,"h:mm a/p")
André