Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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