I am trying to add a date to the end of the file name when I export data out of Alteryx as an Excel Binary .XLSB file. When I run the workflow, I always want the date to be the last calendar day of the previous month in the file name. (I.e. Myfilename 2023 02 28.xlsb) What formula should I use? I can't seem to get the right output as it is always adding time to the end like Myfilename 2023 02 28 00:00:00.xlsb). Any help would be greatly appreciated!
I got it to work! In the output options, I changed setting # 3, Output options from "Create New Sheet" to "Overwrite File (Remove)". That seemed to have done the trick.
So sorry to have kept bothering you! Thanks so much for your help!
oh no problem- tbh this is fascinating - you would have had different results for a .xlsx - so this is good to read. (.xlsx would have said sheet already exists or something)
