Forum Discussion

MervinWorrell's avatar
MervinWorrell
Qrew Member
7 years ago

this formula is not producing any errors but nothing shows up in the report

If([Client] = "Equitrax" and [REPORT COMPLETE?] = "YES", [Date Report Completed]+
Days(93),
If([Client] = "MARK2MARKET" and [REPORT COMPLETE?] = "YES", Date(Year([Date Report Completed]), Month(AdjustMonth([Date Report Completed],1)), 10),
If([Client] = "DISPO SOLUTIONS" and [REPORT COMPLETE?] = "YES", [Date Report Completed]+ Days(48),
If([Client] = "RELS VALUATION" and [REPORT COMPLETE?] = "YES", [Date Report Completed] + Days(3),
If([Client] = "Inside Valuations" and [REPORT COMPLETE?] = "YES", [Date Report Completed]+ Days(48),
If([Client] = "Pro Tek" and [REPORT COMPLETE?] = "YES", [Date Report Completed] +
Days(48),
If([Client] = "CORE LOGIC" and [REPORT COMPLETE?] = "YES", [Date Report Completed] + Days(3),
If([Client] = "RRREVIEW" and [REPORT COMPLETE?] = "YES", [Date Report Completed] +
Days(16),
If([Client] = "CLEAR CAPITAL" and [REPORT COMPLETE?] = "YES" and [Date Report Completed] < Date(Year([Date Report Completed]),Month([Date Report Completed]),16),
Date(Year([Date Report Completed]), Month([Date Report Completed]), 17),
If([Client] = "CLEAR CAPITAL" and [REPORT COMPLETE?] = "YES" and [Date Report Completed] >=Date(Year([Date Report Completed]),Month([Date Report Completed]),16)and [Date Report Completed] <= Date(Year([Date Report Completed]),Month([Date Report Completed]),31), Date(Year([Date Report Completed]),Month(AdjustMonth([Date Report Completed],1)),3),
If([Client] = "PCV MURCOR" and [REPORT COMPLETE?] = "YES", FirstDayOfPeriod([Date Report Completed], Weeks(1), Date(2015,1,3)) + Days(36),
If([Client] = "EMORTGAGE LOGIC" and [REPORT COMPLETE?] = "YES", [Date Report Completed] + Days(10)))))))))))))
  • HI Mervin,

    when looking at this report does the field show up as blank on the report? Also does the formula work on the form?