Notion Answers

Get help from other Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

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

1 Answer

1vote

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.

Please log in or register to answer this question.

Exclusive for Notion Answers Users

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect