krishnabsharma
New Member
Hi Team,
Greetings!
Need your help on issue i am facing -
Information: Have 6 Date columns (Date1 to Date6) and 2 resulting columns as "12M" & "36M" which are dependent on these 6 date columns.
Problem Statement:
With this scenario, the value should be "Compliant" as minimum 3 columns are within a YEARS range.
Likewise it will be for "36M" outcome column. Each date column should be within a YEARS range then ONLY it will be a "Compliant".
Attached is the sample data.
Can you please help me get this completed? Thanks.
Regards,
Krishna
Greetings!
Need your help on issue i am facing -
Information: Have 6 Date columns (Date1 to Date6) and 2 resulting columns as "12M" & "36M" which are dependent on these 6 date columns.
Problem Statement:
- If any of 4 Dates columns out of 6 are less than a Years duration then "12M" should have "NonCompliant" else "Compliant"
- If any of the Dates columns out of 6 is less than a Years duration then "36M" should have "NonCompliant" else "Compliant"
With this scenario, the value should be "Compliant" as minimum 3 columns are within a YEARS range.
Likewise it will be for "36M" outcome column. Each date column should be within a YEARS range then ONLY it will be a "Compliant".
Attached is the sample data.
Can you please help me get this completed? Thanks.
Regards,
Krishna