Formula for if within date range of a specific date

Question

Hi

I am new to Alteryx and I'm trying to figure out if there is a formula I can use to check if a date falls within a range of dates.

so if the dates in Date, Date 2, Date 3... are within the two week range from the date in "Date of action" then "No issue"

Appreciate any help!

Date range.yxmd

flying008 · Answer

Hi, @hgrego

If this like you want , please mark as solution, then it can help more people.

KSowers10 · Answer

How about something like this?

Date range.yxmd

hgrego · Answer

Hi

I have multiple date columns (more than 20) and I don't think creating new columns to compute the range for each column would work best. So i'm looking perhaps there is a way to check all the columns in one formula.