Help with Date Filer

[ShantanuDagar]

Hello,

I have a MM/YY column.

The format of dates is yyyy-mm-dd

2023-05-23

2023-05-23

2023-05-01

2023-04-23

I want to filter based on year and month only.

Like in may 2023 I want all rows of may and 2023 which will be 1,2,3. Dates should be kept excluded from the filter.

[ShankerV · Accepted solution]

Hi @ShantanuDagar 

One way of doing this.

datetimeformat([Field1],"%b") = "May"

Many thanks

Shanker V

[ShankerV]

Hi @ShantanuDagar 

Use the below formula, if you want to filter only 2023 alone.

datetimeformat([Field1],"%b") = "May" AND
Left([Field1],4) = "2023"

Input was:

Output:

Many thanks

Shanker V

[ShantanuDagar]

Thanks, works good