Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start 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