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.

[ericp]

Let's say that was not always the case, for example:

"Reg1Approval": "N/A",
"Reg2Approval": "05/16/2024",
"Reg3Approval": "07/25/2027",
"Reg4Approval": "12/03/2023",
"Reg5Approval": "01/08/2024",

How can I get the latest from this? I tried using the Latest() function, but can't seem to get it to work

[Lech Kulikowski]

Hello,

Sorry, we did not exactly understand your question. Could you explain your issue in more detail?

Thank you.