Timestamp issue

Hi, I am trying to add a timestamp to a file name. It looks like everything works but the time values always show up as 12 00

This is what i used as the calculated function

"C:\EM\file name - " & format(today(),‘yyyy-MM-dd hh mmtt’) & “.xlsx”

This is what returned:
C:\EM\file name - 2023-03-01 12 00AM.xlsx

Do I have to convert today() to it’s numeric value?

today() returns a whole date, thus no the time part. Use now() instead.

Ugh… I knew it was something simple like that. Thank you…!