This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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