topic Re: auto fill today's date into data table name in Discussions

auto fill today's date into data table name

Isabel26 — Sat, 10 Jun 2023 23:45:24 GMT

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" );

Re: auto fill today's date into data table name

ron_horne — Tue, 08 Mar 2022 18:05:20 GMT

Hi @Isabel26

perhaps this will work:

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

Re: auto fill today's date into data table name

Isabel26 — Tue, 08 Mar 2022 18:21:18 GMT

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

Re: auto fill today's date into data table name

Jeff_Perkinson — Tue, 08 Mar 2022 18:57:33 GMT

You need to Format the date:

Format( Today(), "ddMonYYYY" );

Two things to note:

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

Re: auto fill today's date into data table name

Isabel26 — Tue, 08 Mar 2022 19:19:39 GMT

Thank you! It worked perfectly.