Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Add Last Day Of Previous Month to .xlsb export

RCern
8 - Asteroid

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!

11 REPLIES 11
RCern
8 - Asteroid

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
19 - Altair

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)

Labels
Top Solution Authors