Creating reports and dashboards | Stimulsoft community forum

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"

Hello,

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

Thank you.

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

Hello,

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

Thank you.