Date Condition

[jonick1205]

Hello,

I have this given date is 06/22/21 and from 06/01/21 to 06/30/21 i only need to show the dates from 06/22/21 less than 10 days.

Thank you in advance

[Maskell_Rascal]

I don't understand the question. 

[jonick1205]

from the date 06/01/21 to 06/31/21 and my given date is 06/22/21 

i only need to show the dates 06/22/21, 06/23/21, 06/24/21, 06/25/21, 06/26/21, 06/27/21, 06/28/21, 06/29/21, 06/30/21 since my condition is 10 days from 06/22/21

[Maskell_Rascal]

So based on date provided, you want to filter to dates that are 10 days greater than the date provided, provided that they fall within the given month?

So for example, the date of 6/13/21 would return 6/13-6/22. But the date of 6/27/21 would return 6/27-6/30, since there are not enough days left in the month to give a full 10 days looking forward. 

[jonick1205]

Absolutely Correct!

[Maskell_Rascal · Accepted solution]

Hey @jonick1205 

So I have a solution for you. I'm not sure how you have your data setup, so the workflow attached has the filter date hardcoded into the formula. You can make this more dynamic with a couple small changes if needed. 

First I'm adding a column to the data to get the last day of the month. 

After that, I can apply the filter. 

As you can see, it will return 10 dates based on the date provided, and as long as all dates fall within the month. 

If this solves the problem please mark answer as correct, if not let me know!

Cheers!

Phil