topic Re: Difference between the data of latest two dates in App Development

Difference between the data of latest two dates

Rajakumaranakash — Sat, 22 Feb 2025 12:13:57 GMT

I want to get the data difference from latest 2 dates. For Example

I want to get the result as below.

Newly Added Name

Richard

Removed Name

Tom

Can someone help on this?

Chanty4u — Thu, 20 Feb 2025 19:46:00 GMT

Try this

Concat(DISTINCT {<[Date]={"$(=Max(Date))"}> } Name, ', ') -

Concat(DISTINCT {<[Date]={"$(=Max({<[Date]={"<$(=Max(Date))"}>} Date))"}>} Name, ', '

)

morgankejerhag — Sat, 22 Feb 2025 05:09:09 GMT

I am not sure how you mean - Richard, which is only present in the last day (20th) is flagged as removed?

rubenmarin — Sat, 22 Feb 2025 08:01:20 GMT

Hi, names added on last date that was not present in the previous to last date (Added?):

Concat({<ID=P({<Date={"$(=Date(Max(Date)))"}>} ID)-P({<Date={"$(=Date(Max(Date)-1))"}>} ID)>} Name, ', ')

Names present in the previous to last date that not exists on max date (Removed?):

Concat({<ID=P({<Date={"$(=Date(Max(Date)-1))"}>} ID)-P({<Date={"$(=Date(Max(Date)))"}>} ID)>} Name, ', ')