Help with DateTime Tool in Alteryx Designer 2018.4

[rishabh_surendran]

When the DateTime tool converts yy (input) to yyyy (e.g. 15 to 2015), why does Alteryx assume that I'm referring to 2015 and not say 1915 or 1815? 

[Thableaus · Accepted solution]

Hi @rishabh_surendran

Here's the explanation for that.

 - yy Year represented only by the last two digits. When converting from a string, two digit years will be mapped into the range from current year minus 66 years to the current year plus 33 years. So, in 2016, a two-digit year will be mapped into the range 1950 to 2049. (On input, four digits will also be accepted.)

https://help.alteryx.com/2018.3/DateTime.htm

Cheers,

[rishabh_surendran]

Thank you!

Indeed a great logic.