Filter by expression

[Venkatsj]

Hi , 

Please help me with the below question.

Doc Number	Owner	Expired Date
1	Max	Feb-21
2	Fury	Aug-19
3	Kit	Jun-19
4	Kate	Mar-19
5	Bell	Feb-20
6	Kale	May-21
7	Maddy	Jun-20
8	Nimby	Dec-21
9	Kiwi	Jan-21
10	Russel	Feb-21
11	Buffy	Mar-20

From the above table I want to use filter expression for the column "Expired Date" I want to filter the dates only between June 2021 to Dec 2021. Can someone help me with the expression ?

Thanks

[Ponkaviyarasu · Accepted solution]

Hi Friend,

Use this expression in Expired date:

1#:

Use date function to change format [your wish - Date(Date#(Expireddate,'YY-MMM'))]. 

=aggr(only({<Expired_Date={">=6/1/2021<=12/1/2021"}>}Expired_Date),Expired_Date)

2#:

Uncheck 'Include null Values'

[Venkatsj]

Thank you it worked. 

[Ponkaviyarasu]

Hi,

Kindly Mark this  as 'Solved'😊.