Error in formula when using BAQ in a Crystal Report

ERP 10
1

I am modifying one of our existing crystal reports to pull data from a BAQ instead of from an ODBC connection and I am having an error message “A date is required” with one of the formulas to calculate business days. The formula works perfectly in the ODBC connected report, but not in the same report that uses the BAQ. The BAQ definition for the report shows type “date” for all of the date fields. I have modified the syntax in the formula to use date() function for the date field, but even though it doesn’t throw an error, the calculated days are always zero.
I have included a few screen shots.

Any help would be greatly appreciated!

Daniel Dell’Aquila

otr1.PNG1081×773 28 KB
otr2.PNG1170×761 37.7 KB
otr3.PNG892×643 30.1 KB
otr4.PNG1171×755 37.9 KB

2

I think I found the solution to my problem. For some reason the date fields in the BAQReportResult were converted to DateTime regardless that the BAQ definition is date. So I created a formula to convert to date each date used in the calculation and it works!

3

From what I’ve noticed, that’s just for display purposes inside of Epicor. The underlying data fields do not change unless you use conversion formulas in calculated fields.

Pedro

4

Got it. Thank you Pedro.