Conditional Formula; Shred by Date
I am hoping to generate a date field or text field (Shred by Date) based off the following conditions: If client's age at discharge is (equal to or > 18) shred by date = discharge date + 7 years. ...
Forum Discussion
If([Client's Age at Discharge]<18,
[Client's DOB]+Years(25),
[Client Discharge Date]+Years(7))
[Client's DOB]+Years(25),
[Client Discharge Date]+Years(7))