Free Trial

Alteryx Designer Desktop Discussions

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

dd- month-yy in alteryx changing into d-month-yy in excel output

Padminid
5 - Atom

I used data time tool and date into string in format d d-Month-y y only for single dates the output in excel does not have leading zero. 

 

example - in Alteryx I see as 01-April-21 but in excel it is 1-April-21 

 

Please help me with a quick fix

1 REPLY 1
RolandSchubert
16 - Nebula
16 - Nebula

Hi @Padminid 

 

if you use "dd-Month-yyyy" as a customer format in the DateTime tool, you should get leading zeros for the day.

 

Let me konw if it works for you.

 

Best,

 

Roland

Labels
Top Solution Authors