Notion Templates
Notion Templates/
All Templates
All Templates/
🌋
Auto-populate Dates
🌋

Auto-populate Dates

Master Tag
Tips & Tricks
Created
Jun 30, 2020 02:25 PM
How It Works
https://www.youtube.com/watch?v=IRIWfhDalwI
Usage
Web Tags
Database
Formula
How To
Alternatives
Cover
Video Tour
Video preview
 
Combining Views
Time
-
Date
Year
Month(Full)
Month (abb)
Month (#)
Bi-Annual
Quarter
Weekday
Weekday (abb)
Weekday (#)
Day (Date)
Day into Year
Week (#)
Month-Day
Weekday-Month-Day
Date-Elapsed (days)
→
‣
→
Jun 30, 2020
→
Jul 1, 2020
→
Jul 2, 2020
→
Jul 3, 2020
→
Jul 4, 2020
→
Jul 5, 2020
→
Jul 6, 2020
→
Aug 1, 2020
→
Sep 2, 2020
→
Oct 7, 2020
→
Nov 2, 2020
→
Dec 12, 2020
→
Jan 1, 2021
→
Feb 2, 2021
→
Mar 4, 2021
→
Apr 10, 2021
→
May 5, 2021
Basics Formulas
Year → year(prop("Date"))
Month(Full) → formatDate(prop("Date"), "MMMM")
Month(abb) → formatDate(prop("Date"), "MMM")
Month (#) → formatDate(prop("Date"), "MM")
Bi-Annual → (month(start(prop("Date"))) > 5) ? "Second" : "First"
Quarter → if(month(prop("Date")) < 3, "Quarter 1", if(month(prop("Date")) < 6, "Quarter 2", if(month(prop("Date")) < 9, "Quarter 3", if(month(prop("Date")) < 12, "Quarter 4", ""))))
Weekday → formatDate(prop("Date"), "dddd")
Weekday(abb) → formatDate(prop("Date"), "dd") or formatDate(prop("Date"), "ddd")
Weekday (#) → formatDate(prop("Date"), "d")
Day(Date) → formatDate(prop("Date"), "DD")
Day into Year → formatDate(prop("Date"), "DDD")
Week (#) → formatDate(prop("Date"), "W")
Time → formatDate(prop("Date"), "h:mm A") or formatDate(now(), "h:mm A")
Month-Day → formatDate(prop("Date"), "MMM, DD")
Weekday-Month-Day → formatDate(prop("Date"), "ddd: MMM, DD")
Date-Elapsed (days) → dateBetween(prop("Date"), now(), "days")
 
Novice Formulas
Year 2 → concat(format(year(start(prop("Date 2")))) + " → " + format(year(end(prop("Date 2")))))
Month (abb) 2 → concat(formatDate(start(prop("Date 2")), "MMM") + " → " + formatDate(end(prop("Date 2")), "MMM"))
Quarter (end) → if(month(end(prop("Date"))) < 3, "Quarter 1", if(month(end(prop("Date"))) < 6, "Quarter 2", if(month(end(prop("Date"))) < 9, "Quarter 3", if(month(end(prop("Date"))) < 12, "Quarter 4", ""))))
Days Between 2 → dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days")
Percentage-Days Elapsed (Today) → (divide(dateBetween(now(), start(prop("Date 2")), "days"), dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days")) > 0) ? (round(100 * divide(dateBetween(now(), start(prop("Date 2")), "days"), dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days"))) / 100) : toNumber("")
Emoji-Percentage-Days Elapsed (Today) → (divide(dateBetween(now(), start(prop("Date 2")), "days"), dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days")) > 0) ? (slice("⌬⌬⌬⌬⌬⌬⌬⌬⌬✓", 0, dateBetween(now(), start(prop("Date 2")), "days") / dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days") * 10) + " " + format(round(divide(dateBetween(now(), start(prop("Date 2")), "days"), dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days")) * 100)) + "%") : ""
⌬✓