The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

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

Date

Suryachoppakatla
7 - Meteor

Hi,

 

I am looking for a help with an IF CONDITION to give a result as VALID or INVALID

 

IF the type of account holder is "Individual" AND The Birth Date format is  YYYY-MM-DD, then VALID else INVALID. I have to refer two fields in conjunction to each other

 

I have attached a sample data for quick ref

 

Thank you

5 REPLIES 5
binuacs
21 - Polaris

@Suryachoppakatla One way of doing this

binuacs_0-1683228346720.png

 

geraldo
13 - Pulsar

@Suryachoppakatla 

 

AN EXAMPLE

 

geraldo_0-1683228821476.png

 

 

 

MilindG
12 - Quasar

@Suryachoppakatla Another way to do this.

MilindG_0-1683229108238.png

 

Suryachoppakatla
7 - Meteor

Thank you all for your replies, however it's not meeting my purpose. I believe my question is little confusing. Please see what I wrote a formula and am getting 'Invalid" reslut

 

Not sure where I am doing wrong

 

Thanks

geraldo
13 - Pulsar


In my example I didn't put the filter Type of Account Holder = "Individual' and ....
I just did the date validation test

Labels
Top Solution Authors