Hi All,
This post is more of a comment on the Alteryx help page for Date Time Functions. Please click link below to see the help page:
https://help.alteryx.com/10.0/index.htm#Reference/DateTimeFunctions.htm%3FTocPath%3DReference%7C_____21
Scrolling down to the "Date/Time Format Flags" section it states:
...The year format specifier (both %y and %Y) can read either two or four digit years. Two digit years are always given "20" as the century. Therefore, a two digit year of "99" will translate to "2099", not "1999"....
However, I have found that 2-digit years are not always given the "20" century. I have noticed that 00 to 50 are given the "20" century i.e. assigned as 20XX. But 51 to 99 are given the "19" century i.e. assigned as 19XX. Please see attached workflow where I run both Date Time Tool and DateTimeParse functions on a couple of 2-digit year dates (using both %y and %Y specifiers and get same results each time).
Please can my observations be confirmed and if this is indeed true could the help page please be corrected?
Thanks so much.
Yusuf
