ShannonMcFarlin
8 years agoQrew Trainee
syntax error
Syntax error for Max([Referral Date],[2nd Referral Date],[3rd Referral Date]) If(<[Most Recent Referral Date], null)
We are trying to leave a field blank if it is less than the "most recent referral date"field. This formula works for our max value between referral dates, but not for the If statement
We are trying to leave a field blank if it is less than the "most recent referral date"field. This formula works for our max value between referral dates, but not for the If statement