• Add (..th..st..rd) to numbers with "o" [ex. Do = 3rd]
• Turn format into a numerical value: wrap with toNumber() [ex. toNumber(formatDate(prop("Date"), "Q"))]

Quarter

Formula

formatDate(prop("Date"), "Q")

Action

Quarter 1-4

Week Number

Formula

formatDate(prop("Date"), "w")

Action

Week # Starting Sunday (1-52)

Formula

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

Action

Week # Starting Monday (1-52)

Year

Formula

formatDate(prop("Date"), "YYYY")

Action

YYYY (2021)

Formula

formatDate(prop("Date"), "YY")

Action

YY (21)

AM/PM

Formula

formatDate(prop("Date"), "a")

Action

am/pm

Formula

formatDate(prop("Date"), "A")

Action

AM/PM

Weekday