Filtering data

[arkimp]

I have input like below.  I want to extract data based on the Current date.. 

If the "current date /system date" is < 7 ,  all the data to be extracted.  If the  "current date /system date" is > 7 , only current month data to be extracted..

Input:

Date	value
2022-07-21	10
2022-07-22	20
2022-08-01	40
2022-08-09	50

As today's Date is 12, only this month data to be in output file.  please let me know, how can i achieve this?

Output:

Date	value
2022-0801	40
2022-08-09	50

[DataNath]

3rd edit: Realised my first attempt should actually be fine.

[ArtApa]

Hi @arkimp - Here is a possible solution:

[ArtApa]

@arkimp - The difference between my and @DataNath solution is that my solution will process all records with one date. While the second solution will generate a date for each record and at midnight it will change.

[flying008]

Hi,@arkimp 

only filter as you need:

DAY(DateTimeToday())<7 || (DAY(DateTimeToday())>7  && MONTH([Date])=MONTH(DateTimeToday()))

[DavidP]

Hi @arkimp 

I would typically do this in 2 steps with a formula and filter tool as I find it a bit easier to articulate the logic in a formula tool. 

One thing to note: What should happen on the 7th day of the month? I used  >= 7 for my logic