Selecting Latest Date from Multiple Values

[ericp]

Hello there, so I want to get an output that displays the latest date from the values in my JSON object, but i'm having a hard time getting it to work.

I'm not sure of the expression I would have to write to get this to work.

For example, my JSON looks like:
"Reg1Approval": "N/A",
"Reg2Approval": "05/16/2024",
"Reg3Approval": "07/25/2024",
"Reg4Approval": "12/03/2024",
"Reg5Approval": "01/08/2025",

I want to look at all "Reg1-5Approvals" and have the latest date displayed (which would be the value "01/08/2025"

[Lech Kulikowski]

Hello,

You can use the Last() function from the Dictionary.

Thank you.