Hello,
Can someone help guide on how I can change the string format of date to date format.
Input: yyyymmdd
Output: mm/dd/yyyy
TDATE | OUTPUT |
20220221 | 02/21/2022 |
20220126 | 01/26/2022 |
20230221 | 02/21/2023 |
20230103 | 01/03/2023 |
TDATE is my input and OUTPUT is the output I am expecting. The data type for OUTPUT should be "Date"
Thank you.
Hi @nirvapatel1998,
for clarity, Alteryx only stores dates as a Date data type in the ISO format - YYYY-MM-DD. If you want it to be formatted as MM/DD/YYYY coming out of Alteryx, it will have to stay as a string. Is this alright?
Otherwise if you want to store it as a Date ans indicated, you can change the display format on the Excel side if you want it to stay as a Date data type in Alteryx.
-Alex
@nirvapatel1998 One way of doing this. as @alexnajm said mm/dd/yyyy is not a valid date format in Alteryx