Alteryx Designer Desktop Discussions

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

DateTime Parse tool

Kshen
7 - Meteor

Hello, 

I have a date time column that I'd like to convert format. The column currently is V-String. I used the DateTime tool as the following screen shot, but the column returned in blank. Can someone please tell what was wrong? Thanks 

 

 

Current format: YYYY-MM-DD

New format: MM/DD/YYY. 

Kshen_0-1648852862632.png

 

4 REPLIES 4
Tyro_abc
11 - Bolide

Can you please attach sample data?

Kshen
7 - Meteor

Kshen_0-1648853577473.png

Here is current format. Do you need me to attach the excel file? 

 

 

Tyro_abc
11 - Bolide

Can you try the formula tool to format the date?

 

Tyro_abc_0-1648853956502.png

Let me know if you are facing any issue with this

Kshen
7 - Meteor

Fabulous! It worked. Didn't know the Capitalized Y makes the difference. I first tried lower case y, it only gave me two digit year, but once I change it to Y, it give me 4 digits. Tricky! Thanks 

 

 

Labels