Finding Payment Due Date

[BobjiK]

Hi 

This is the requirement I have.

I need to flag those rows that falls within Today & 21 days from Today, in reverse. There is a column that shows the elapsed days in negative

I need to find those rows that falls between today & -21 days from today.

I hope that I have explained clear enough

[ChrisTX]

Can you use a Filter tool with formula

IF [Blocked OD] <=0 and [Blocked OD] >= -21

[Deano478]

@BobjiK you can maybe try something like this

DateTimeToday() <= [YourDateField] AND [YourDateField] <= DateTimeAdd(DateTimeToday(), 21, 'days')

[BobjiK]

Thanks @Deano478 & @ChrisTX 

Let me try your solutions