Hi, I've been looking through the forums but haven't quite figured out my date conversion problem.
The date format I have is: 12/30/2017 17:29:42:123
The date format I would like is 20171230
I have tried a few different formulas but when I get to actually converting the date format I get a conversion error saying the date is not valid.
I have tried trimming the left 10 digits but due to some dates being 1/5/2017 they come out with a 0 at the end.
Thank you for any help.
DateTimeFormat(DateTimeParse([Date],"%m/%d/%y"),"%Y%m%d") should work ...
Try this formula:
Use this guide for dateformats: https://help.alteryx.com/9.5/Reference/DateTimeFunctions.htm
Part time Tableau, Part Time Alteryx. Full Time Awesome