Best way to convert 01.01.2017 string to date?

Question

Hello!

I have a file where the dates are listed in the format "01.01.2017".  I've read a bunch of posts about different ways to convert dates in Alteryx, but I'm still not clear on what will work best for this situation and am afraid I'm overcomplicating it!  Can someone make a recommendation on the best way to convert this to a date that Alteryx can use?

Thanks!

Caroline

MarqueeCrew · Accepted Answer

DateTimeParse([field],”%m.%d.%Y”)

That’s the direct way to create your date.

Cheers,

Mark