Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'
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'
Thank you it worked.
Hi,
Kindly Mark this as 'Solved'😊.