Someone help me with a code to countdown Years, Months, Weeks, Days, Hours and Minutes in a single formula property and a single date property (using the ranges as well)
Connect
1 Answer
You can use a Notion formula like this:
format(dateBetween(prop("Date"), now(), "years")) + "y " + format(dateBetween(prop("Date"), now(), "months")) + "m " + format(dateBetween(prop("Date"), now(), "days")) + "d " + format(dateBetween(prop("Date"), now(), "hours") % 24) + "h " + format(dateBetween(prop("Date"), now(), "minutes") % 60) + "m"
Use Date for your Notion property name and it will work as you need.
Without Answer
-
- 41
- 0
- 3 days ago
-
- 1115
- 0
- Apr 14
-
- 625
- 0
- Apr 12
-
- 959
- 0
- Apr 11
-
- 547
- 0
- Apr 10
-
- 567
- 0
- Apr 7
-
- 574
- 0
- Apr 6
-
- 538
- 0
- Apr 4
- see all
Recent Activities
tipkilby asked 3 days ago
How to turn a notion database table into just a da…notionbackups answered May 22
How to print or export note or page as pdf with fi…notionbackups answered May 22
How to fix messed up decimal numbers after import …pjbdr026 asked Apr 14
How do teams use Notion for collaboration?pjbdr026 asked Apr 12
CRM System in Notion
...

