I binary loaded my app on 12/1 using Sense version April 2018. I upgraded on 12/2 to September 2018 and re-run my binary load a few days later. My max function stops working. For load on 12/1 it returns a number like 43434. On load after upgrade it returns a formatted month year like Oct-2018.
What could be causing this? Does this sound upgrade related or some other issue?
I am not sure why it was working before, and not working now after upgrade.
But see below explanation, if it can help.
MAX works on numeric values, where as MaxString works on string values. Since date values are dual, by using MAX function over it, gave you numeric value of the field.
Thanks for providing documentation. The numeric value is what's desired, but why then does max return the formatted date in my screenshot. Is this a bug? In my experience the max function has always returned a numeric value.
