Hi,
Does Appian have any defualt function to get the Max/ latest date from a date array if the data is like below?
2018-10-26T20:41:55
2017-02-26T18:21:39
2019-07-26T10:01:21
Thanks in Advance
Discussion posts and replies are publicly visible
I believe dates in that format will sort lexically consistently (i.e. a standard "alphabetical" sorting will sort the dates correctly, assuming they're TEXT and with no other conversion necessary), in which case I'd expect the "max()" function might work for you.
Thanks for the suggestion Mike. I tried to use the max function and for ( List of Text String: 2 items "2018-12-04T19:24:44" "2017-09-26T20:41:35") and this is what I got -2.017093e+13
My mistake, max() does expect a numeric value. The place I've used it for finding the max date from a list is being called on an array of dateTime value.