DateTime Parse tool

[Kshen]

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. 

[Tyro_abc]

Can you please attach sample data?

[Kshen]

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

[Tyro_abc · Accepted solution]

Can you try the formula tool to format the date?

Let me know if you are facing any issue with this

[Kshen]

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