Add Last Day Of Previous Month to .xlsb export

[RCern]

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!

[RCern]

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!

[apathetichell]

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)