Forum Discussion

CourtneyCourtne's avatar
CourtneyCourtne
Qrew Member
9 years ago

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.  ...
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
My mistake on the years.

A better use is: 

If([Client's Age at Discharge]<18,
AdjustYear([Client's DOB], 25),
AdjustYear([Client Discharge Date], 7))