Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

Date time format Input data with month name

kathbanc
Astéroïde

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 RÉPONSES 2
BRRLL99
Bolide

Hi 

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

 

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

kathbanc
Astéroïde

It works! Thank you so much. 

Étiquettes