I need to add the date and time to the same file name every time I run a project using the “Export into delimited text file” action.
I have succeeded in adding just the date to the filename with:
’G:\My Drive\Finance\MyFileName ’ & format(today(), ‘yyyy-MM-dd’) & '.csv’
as a parameter
the result is a file with the name: MyFileName 2019-10-15.csv
but when I change that parameter to:
’G:\My Drive\Finance\MyFileName ’ & format(now(), ‘yyyy-MM-dd HH:mm’) & '.csv’
I get “The given path’s format is not supported”
I need the file to be named:
MyFileName 2019-10-15 13:45.csv
Thanks for any help!