Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We’re thrilled to announce our newest Alteryx Designer Expert Certified users! Learn more.

Date conversion

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 ...





See attached.



Alteryx Certified Partner

Hey @Rrmbinson10


Try this formula:


DateTimeFormat(DateTimeParse(Left([Date],Length(Date)-4),"%m/%d/%Y %H:%M:%S"),"%Y%m%d")

Use this guide for dateformats:



Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover