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)))))))))))))
Question
this formula is not producing any errors but nothing shows up in the report
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.