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
-
- 162
- 0
- Jul 9
-
- 446
- 0
- Jun 11
-
- 917
- 0
- Jun 4
-
- 641
- 0
- May 19
-
- 264
- 0
- May 16
-
- 605
- 0
- Apr 29
-
- 582
- 0
- Mar 14
-
- 531
- 0
- Feb 21
- see all
Recent Activities
Imrul answered 2 days ago
Formula for an automation that sets due-date to ne…Imrul answered 2 days ago
Counting Stars?CATA asked Jul 9
notion do not open in my Windows PC
...