DateTime Parse tool

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.

Date Time

Accepted answers

Can you try the formula tool to format the date?

Let me know if you are facing any issue with this

DateFormat.yxmd

All comments

Can you please attach sample data?

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

Can you try the formula tool to format the date?

Let me know if you are facing any issue with this

DateFormat.yxmd

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

Quick Links

Tags

This months top contributors

Hollingsworth 335