dd- month-yy in alteryx changing into d-month-yy in excel output
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Padminid
5 - Atom
‎06-25-2021
04:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Date Time
1 REPLY 1
16 - Nebula
‎06-25-2021
04:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
