Date is between two Dates

[SomuGS]

Hi,

I'm trying to find a solution, where I need "X" in a column when it falls within a specific date range. Any help would be appreciated. Thanks!

[ShankerV · Accepted solution]

Hi @SomuGS 

Yes, it is possible.

Step 1: Convert the date to alteryx format date, YYYY-MM-DD (Date time tool)

Step 2: Then use the formula tool using if between condition and then mark X.

Many thanks

Shanker V

[ShankerV]

Hi @SomuGS 

Please find the below solution.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[PanPP]

Hi @SomuGS 

I have provided a sample WF that accomplishes your output.