Date

[Suryachoppakatla]

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

[binuacs]

@Suryachoppakatla One way of doing this

[geraldo]

@Suryachoppakatla 

AN EXAMPLE

[MilindG]

@Suryachoppakatla Another way to do this.

[Suryachoppakatla]

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]

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