MervinWorrell
7 years agoQrew Member
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)))))))))))))
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)))))))))))))