Question

Hello,

I have a row from database 1 which is using by another database 2 with a relation. With that a have this relation in database 1 each time I use the row from database 1 in database 2. I used a rollup in DB1 to get dates from DB2 associated.
Then I have several dates in one property in DB1. I would like to get the max between all these dates but no possible to get it because I'm not able to convert in date.

Do you have any idea ?
I could explain more if need.

Thanks in advance!

Best regards

Answer 1

When you rolled up the dates, in the third option of the rollup, it will give you a choice to choose "Range". This will give you the max days between the earliest and latest. You can also create two rollups, one for the earliest and the other for the lastest and create a formula for the dateBetween to give you the same answer.