Alteryx Designer Desktop Discussions

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

Date time format Input data with month name

kathbanc
8 - Asteroid

Hello,

 

I am new to Alteryx, I have a question regarding the date and time format.

 

Input

24-Jan-2022

 

 

Output Expected

2022-01-24

2 REPLIES 2
BRRLL99
11 - Bolide

Hi 

use Formula tool and try this expression DateTimeParse([date ],'%Y-%b-%d')

 

[date] >> will be your column name in the expression

kathbanc
8 - Asteroid

It works! Thank you so much. 

Labels