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
-
- 52
- 0
- 3 days ago
-
- 159
- 0
- Aug 12
-
- 216
- 0
- Aug 7
-
- 302
- 0
- Jul 17
-
- 1361
- 0
- Apr 14
-
- 942
- 0
- Apr 12
-
- 881
- 0
- Apr 10
-
- 875
- 0
- Apr 7
- see all
Recent Activities
blackcrow asked 3 days ago
Global Client Filter Across Multiple Database View…benarik answered Aug 27
Display backlinks in a block or page?benarik answered Aug 27
Can I see all inbound broken links in a public not…benarik answered Aug 27
Looking for clarity on copying DB keysbenarik answered Aug 26
How Can I Use Notion to Organize a Busy Work Workf…
...

