Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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