Skip to main content

Hi everyone,

Could anyone help with this? I need to save a workbook with a filename that includes yesterday’s date (Today − 1). I can compute T-1 using Date & Time → substract to date and store it in a variable—that part works.

 

 

However, when I use Excel Advanced → Save As, the File path field doesn’t seem to recognize my variable.

Thanks!

Hi!  The output from your subtract action is a DateTime variable.  In order to use that variable in a filename you will need to first convert it to a string.  You can then use that string variable in your filename:

 

 

Excellent suggestion, ​@PMosman. What you must watch out for, ​@andrelo_jimenez, is that you choose a date format without “illegal” characters for filenames.

MyExcel 9/26/2025.xlsx is not legal because the file system does not allow slashes in filenames.

MyExcel 2025-09-26.xlsx is legal.

Illegal characters in filenames include < > : “ \ | / ? *

Terms & ConditionsCookie settingsAccessibility statement