Dates

Day

formatDate(prop("Date"), "ddd")

Week

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

<aside> ⚠️ Change lowercase w to uppercase W if your weeks start on Monday.

</aside>

Month

formatDate(prop("Date"), "M")

Year

formatDate(prop("Date"), "Y")

Filter Comparisons

All Wednesdays

Using Day Property

Day Is Wed

Using Date Property

Not possible.

Weekends

Using Day Property

Day Is Sat

Or Day Is Sun

Using Date Property

Not possible.

2020: February

Using Day and Month Properties

Year Is 2020

And Month Is 2

Using Date Property

Date Is On Or After Exact Date Feb 01, 2020

And Date Is On Or Before Exact Date Feb 29, 2020

2020: Week 1

Using Day and Week Properties

Year Is 2020

And Week Is 1

Using Date Property

Date Is On Or After Exact Date Jan 01, 2020

And Date Is On Or Before Exact Date Jan 05, 2020