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
-
- 87
- 0
- 1 day ago
-
- 72
- 0
- 5 days ago
-
- 479
- 0
- Apr 29
-
- 444
- 1
- Mar 20
-
- 447
- 0
- Mar 14
-
- 400
- 0
- Feb 21
-
- 391
- 1
- Feb 14
-
- 450
- 0
- Feb 13
- see all
Recent Activities
jcarminio asked 1 day ago
Thoughts on adding Notion AI's web search access i…amandabee asked 5 days ago
Display backlinks in a block or page?amandabee answered 5 days ago
Counting Stars?polle answered 6 days ago
Counting Stars?amandabee answered May 13
settings of font colour changed?
...