O
Oliver
How do I format time to show 01:15 PM instead of 1:15 PM?
I need to add 0 for hours 1 - 9.
Thanks
Oliver
I need to add 0 for hours 1 - 9.
Thanks
Oliver
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Art
Hi Oliver,
use an input mask for Medium Time.
Hope This Helps
use an input mask for Medium Time.
Hope This Helps
G
Guest
I've tried that.I get times in my combo box in this format
1:00:00 AM
1:15:00 AM
..
..
..
If I enter the input mask 09:00\ >LL;0;_ I get error
msg "the value you entered isn't appropiate....."
Thanks
Oliver
1:00:00 AM
1:15:00 AM
..
..
..
If I enter the input mask 09:00\ >LL;0;_ I get error
msg "the value you entered isn't appropiate....."
Thanks
Oliver
E
Elwin
=Format([MyDatefield],"hh:nn AM/PM")
or just place the format in the format property of control
hh:nn AM/PM
or just place the format in the format property of control
hh:nn AM/PM