Conditional Formula; Shred by Date

Question

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.
If client's age at discharge is (<18) shred by date = (however many years until the client is 18 + 7 years).

I currently have the following fields already created, but do not know how to make the appropriate formula for the "shred by date" field.

Client's DOB
Client's current age (formula field)
Client's discharge date
Client's age at discharge (formula field)

mcfneil · Answer

If([Client's Age at Discharge]&lt;18,[Client's DOB]+Years(25),[Client Discharge Date]+Years(7))

courtneycourtne · Answer

THANK YOU! Worked perfectly, except I had to use days instead of years.&nbsp;

mcfneil · Answer

My mistake on the years.A better use is:&nbsp;If([Client's Age at Discharge]&lt;18,AdjustYear([Client's DOB], 25),AdjustYear([Client Discharge Date], 7))

Forum Discussion

Conditional Formula; Shred by Date

3 Replies

Related Content

Formula URL - Edit then Add

Count Formula with Conditions

Formula if with conditional

Create a formula duration over 5 years

Conditional Drop-down

Recent Discussions

Question about relationships

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.