G Guest Sep 22, 2006 #1 How do I get "mm\/dd\/yyyy hh\:nn\:ss" to show the date and time (with AM/PM) in not 24 hour time? Thanks! Adam
How do I get "mm\/dd\/yyyy hh\:nn\:ss" to show the date and time (with AM/PM) in not 24 hour time? Thanks! Adam
F fredg Sep 22, 2006 #2 How do I get "mm\/dd\/yyyy hh\:nn\:ss" to show the date and time (with AM/PM) in not 24 hour time? Thanks! Adam Click to expand... Format(Now(),"mm/dd/yyyy hh:nn:ss AM/PM") 09/22/2006 01:30:22 PM Format(Now(),"m/d/yyyy h:nn:ss AM/PM") 9/22/2006 1:29:43 PM
How do I get "mm\/dd\/yyyy hh\:nn\:ss" to show the date and time (with AM/PM) in not 24 hour time? Thanks! Adam Click to expand... Format(Now(),"mm/dd/yyyy hh:nn:ss AM/PM") 09/22/2006 01:30:22 PM Format(Now(),"m/d/yyyy h:nn:ss AM/PM") 9/22/2006 1:29:43 PM
G Guest Sep 22, 2006 #3 That was quick, thanks! fredg said: Format(Now(),"mm/dd/yyyy hh:nn:ss AM/PM") 09/22/2006 01:30:22 PM Format(Now(),"m/d/yyyy h:nn:ss AM/PM") 9/22/2006 1:29:43 PM Click to expand...
That was quick, thanks! fredg said: Format(Now(),"mm/dd/yyyy hh:nn:ss AM/PM") 09/22/2006 01:30:22 PM Format(Now(),"m/d/yyyy h:nn:ss AM/PM") 9/22/2006 1:29:43 PM Click to expand...
