Dynamic last 3 days

Divyajyothi7

Hi

I'm looking pick last 3 days plus future dates

for example: 

today's date 16-05-2023, it should pick 15,14,13 and future dates also including today's date

tomorrow's date is 17-05-2023, it should 16,15,14 and future dates also including today's date

date
25-05-2017
11-01-2018
01-05-2019
12-05-2023
13-05-2023
14-05-2023
15-05-2023
16-05-2023
17-05-2023
19-05-2025
20-01-2024
21-05-2025
03-07-2028
05-05-2034

Expected output:

13-05-2023
14-05-2023
15-05-2023
16-05-2023
17-05-2023
19-05-2025
20-01-2024
21-05-2025
03-07-2028
05-05-2034

ShankerV

Hi @Divyajyothi7 

Step 1: Convert the date to ISO format yyyy-mm-dd

Datetime tool to be used

Step 2: Use filter tool

Use datetimeadd() function to filter Today-3 days.

Many thanks

Shanker V