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.
Solved! Go to Solution.
Can you please attach sample data?
Here is current format. Do you need me to attach the excel file?
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