Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Validate Date column

jrathod14
5 - Atom

How to validate a date column if it is between 16th of prior month to 15th of next month?

4 REPLIES 4
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @jrathod14,

 

Could you give an example, perhaps with the inputs you have and the output you're looking for?

 

Kind regards,
Jonathan

jrathod14
5 - Atom

Have attach details.Need to check if date column is between 16th of prior month to 15th of next month.

atcodedog05
22 - Nova
22 - Nova

Hi @jrathod14 

 

Here is a workflow for the task.

 

Workflow:

atcodedog05_0-1622053779199.png

 

Although i am still confused about your usage of word prior month🤔 when in the scenario you are checking current month.

 

Hope this helps 🙂

 

apathetichell
20 - Arcturus

2021-05-26 (1).png

See attached - note you have 6/16 marked as a 1 but it should be a zero.

Labels
Top Solution Authors