Short Time?

[Cameo]

What is the correct code to have the Now() be 8:22 pm?

Format(Now(),"Short Time") gives me military time.

Please help!

Thanks!

Cameo

 

[david epsom dot com dot au]

'Short Time' is your system setting
(Start | Settings | Control Panel | Regional Settings)

To override your system setting,

Format(Now(),"h:mm am/pm")
or
Format(Now(),"h:mm AMPM")

(david)

 

[John Vinson]

'Short Time' is your system setting
(Start | Settings | Control Panel | Regional Settings)

To override your system setting,

Format(Now(),"h:mm am/pm")
or
Format(Now(),"h:mm AMPM")

that's actually h:nn - m is months, not minutes! Otherwise exactly
right.

 

[Cameo]

That was too easy! Thank you so much.

Cameo

that's actually h:nn - m is months, not minutes! Otherwise exactly
right.

 

[david epsom dot com dot au]

that's actually h:nn - m is months, not minutes!

trips me every time....

(david)