Date
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Suryachoppakatla
7 - Meteor
‎05-04-2023
12:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Date Time
5 REPLIES 5
binuacs
21 - Polaris
‎05-04-2023
12:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
geraldo
13 - Pulsar
‎05-04-2023
12:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
MilindG
12 - Quasar
‎05-04-2023
12:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-04-2023
01:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎05-04-2023
01:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In my example I didn't put the filter Type of Account Holder = "Individual' and ....
I just did the date validation test
