Daily Journal

Daily Journal

Master Tag
Notetaking
Created
Sep 28, 2021 01:13 AM
Usage
formateDate
Date
Day
Month
Now()
Format
ceil
Web Tags
Database
Layout
Alternatives
Cover

Donate

 
The Daily Journal
The Daily Journal
 
The Daily Journal
The Daily Journal

The Daily Journal
The Daily Journal
Media
notion image
Colors
Red = #fbe4e4
Orange = #faeadd
Yellow = #FCF3DB
Green = #DDECED
Blue = #E0ECF4
Purple = #eae4f3
Gray = #EBECED
 
Formulas

This Month Formula

if(month(prop("Date")) == month(now()), "This Month", if(month(now()) + 1 == month(prop("Date")), "Next Month", if(month(now()) - 1 == month(prop("Date")), "Last Month", "")))

This Week Formula

formatDate(prop("Date"), "W") == formatDate(now(), "W")

Start Week Formula

if(not empty(prop("Date")) and or(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days") == prop("Date"), day(prop("Date")) == 1), formatDate(prop("Date"), "⤵ MMM") + " W" + format(ceil((date(prop("Date")) + day(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days")) - 1) / 7)), "")

Weekday Formula

formatDate(prop("Date"), "dddd")