DateTime tool date mask

[gurth]

When casting string to date, what's the difference between

dy., Month dd, yyyy

and

day, Month dd, yyyy

masks?

The documentation supports the first date mask, but the second one converts the string to a date format too.

https://help.alteryx.com/current/designer/datetime-tool

[randreag · Accepted solution]

hi @gurth 

In effect both converts string to date, the difference is with the first one doesn't expect the complete name of the day while the second one does.

As you can read in the documentation, dy can accept it but it is not its default behaviour

• dy: English day of the week as a 3-letter abbreviation. On input full names are accepted but Alteryx doesn't check that the day of the week agrees with the rest of the date.

Hope it helps