Help with Date Filer

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.

Help

Accepted answers

Hi @ShantanuDagar

One way of doing this.

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

Many thanks

Shanker V

All comments

Hi @ShantanuDagar

One way of doing this.

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

Many thanks

Shanker V

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

Thanks, works good

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703