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