Best way to convert 01.01.2017 string to date?

[carolinemcdonald]

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

[cmcclellan]

This is how I would do it, I've done 2 versions because I don't know if you're talking USA date format "MDY" or Aussie data format "DMY"

So I used the demo data of 01.01.2017 (hard to tell months from dates), 31.12.2017 (Aussie format with day first), 12.31.2017 (USA format with month first)

[MarqueeCrew · Accepted solution]

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

That’s the direct way to create your date.

Cheers,

Mark