auto fill today's date into data table name

[#1]

I need to save as data table to xlsx AND auto adding today's date. For example, file name will be "old name 3/8/2022.xlsx" if I run the script on 3/8/2022, and  "old name 3/9/2022.xlsx" if I run the script on 3/9/2022. This is easy to do in SAS, and I assume JMP will be similar. Not sure how to fix the code. thanks

Data Table( "old name" ) << Save( "C:\old name || Today().xlsx" );

[#2]

Hi @Isabel26 

perhaps this will work:

Data Table( "old name" ) << Save( "C:\old name "|| char (Today())||".xlsx" );

[#3]

Thanks! But the date is not format in MM/DD/YYYY. It returns 3729589915. 

[#4 · Accepted solution]

You need to Format the date:

Format( Today(), "ddMonYYYY" );

Two things to note:

1. You don't need Char() since Format() returns a character string.
2. Avoid the formats that contain slashes (/) since they are used as directory delimiters.  

[#5]

Thank you! It worked perfectly.