Share
ReportHow can i use filter array to filter all dates within the next 30 days? I tried using the below expressions but not of them are working.
Note:- Some of the cells in my data are blank, I want to ignore that empty cells.
Expressions
contains(item()?['Visa Expiry Date'], addDays(utcNow(), 30))
contains(item()?['Visa Expiry Date'], addDays(utcNow(), 30,'yyyy-MMM-dd'))
contains(item()?['Visa Expiry Date'], addDays(utcNow(), 30,'dd-MMM-yyyy'))
Data
Expiry Date
| 31-Mar-23 |
| 14-Feb-23 |
| 27-Feb-23 |
| 13-Sep-23 |
| 17-Oct-22 |
| 17-Oct-22 |
| 14-Nov-22 |
| 17-Oct-22 |
| 25-Jan-24 |
| 19-Jul-24 |
| 20-Jul-24 |
| 13-Oct-23 |
| 7-Mar-23 |
| 1-May-23 |
| 20-Jul-24 |
| 30-May-24 |
Categories:
I have the same question (0)
All responses (
Answers (
8,003
