Finding Payment Due Date

Question

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

Kallis · Answer

Thanks @Deano478 & @ChrisTX

Let me try your solutions

Deano478 · Answer

@Kallis you can maybe try something like this

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

ChrisTX · Answer

Can you use a Filter tool with formula

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