We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Finding Payment Due Date

Kallis
8 - Asteroid

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

 

 

Days.PNG

 

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

I hope that I have explained clear enough

 

3 REPLIES 3
ChrisTX
16 - Nebula
16 - Nebula

Can you use a Filter tool with formula

 

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

 

Deano478
12 - Quasar

@Kallis you can maybe try something like this

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

 

Kallis
8 - Asteroid

Thanks @Deano478 & @ChrisTX 

Let me try your solutions

Labels
Top Solution Authors