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
-
- 457
- 0
- Apr 14
-
- 368
- 0
- Apr 12
-
- 504
- 0
- Apr 11
-
- 309
- 0
- Apr 10
-
- 309
- 0
- Apr 7
-
- 308
- 0
- Apr 6
-
- 302
- 0
- Apr 4
-
- 294
- 0
- Apr 3
- see all
Recent Activities
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 Notionpjbdr026 asked Apr 11
Dashboard Setup
...

