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?