I tried the code and excluded the AM/PM and it worked for me.


Cesar Zapata

"flawed" wrote in message
...
Help please!

I want to append the date and time to a file name, which
is easy enough, but the trouble is, I want the time to
appear in "AM/PM" format and not show the "AM" or "PM".

The only way I know of to do this is to use a format like:

Format(Now(), "YYYY MM DD HH MM SS AM/PM")

I don't want the "AM" or "PM" to appear. Is there another
way to format the time as "AM/PM" so it doesn't show, or
do I need to crop those characters off using something
like the "Left" function?

I prefer a corrected format method, but I don't know what
it would be.

Your example code would be most helpful. Thanks in advance.