Currently I am trying to use the field calculator to generate the most recent date values out of four fields into one field. I attempted to use the max function to calculate the most recent dates but the calculator doesn't seem to be reading the values as dates. For an example, if I have a date that reads 12/9/2016 and one that reads 7/20/2017, the field calculator chooses the first date because it reads the 9 (in the 12/9/2016 date) over the 20 (in the 7/20/2017 date) as the max. The case seems to be that the field calculator doesn't read the values as dates.
Any possible python codes for the codeblock to solve this issue? I'm thinking the datetime function is necessary in this case?