I have 4 fields with Date Time values, and created a new field (Date type as well) which takes the most recent date from these 4 fields. I have tried using the Max python in the field calculator to populate this new field, but it does not use the most recent date from these 4 fields. Does this function not work with Datetime values, or is there another function for this that I am not able to find on these forums.
max([!field1!, !field2!, !field3!, !field4!])
I am on 10.5. When I have two fields that have a date within the same month, it will not read the rest of the date correctly. (See picture attached)
When I run the following updated code it fails and says it is a syntax error.
With the current code, it reads the first number in the day to select the most recent date. (As shown below). It does not use the correct chronological format, even though the strptime format worked previously.