Date conversion

[Rrmbinson10]

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.

[ivoller]

Hi,

DateTimeFormat(DateTimeParse([Date],"%m/%d/%y"),"%Y%m%d") should work ...

Cheers,

Iain

[ivoller]

See attached.

Iain

[LordNeilLord]

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: https://help.alteryx.com/9.5/Reference/DateTimeFunctions.htm

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome