Ben SmithBen Smith
Ben Smith/
Filter by Formatted Date
Filter by Formatted Date
Filter by Formatted Date

Filter by Formatted Date

For
Kyaira
From
Facebook
Status
Updating
Formulas
formatDate
formatDate
Share
Dates

Day

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

Week

formatDate(prop("Date"), "w")
⚠️
Change lowercase w to uppercase W if your weeks start on Monday.

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
 

2021

Using Year Property
Year Is 2021
Using Date Property
Date Is On Or After Exact Date Jan 01, 2021
And Date Is On Or Before Exact Date Dec 31, 2021
 

2020 by Selected Month

Leave the Month filter value blank and update as necessary to easily change months.
 
Year Is 2020
And Month Is [Blank]
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!