I have a Generic Inquiry that sums transactions over a date range specified by Required Parameters StartDate and ThruDate with Default Values of @YearStart and @MonthEnd-1 respectively:
As I needed the ThruDate in Excel exports of this GI, I added it to the Results Grid:
The unexpected result is the Parameter (Thru Date) and the Result column (Statement Date) get different values when the Inquiry is executed:
If the Parameter is manually changed in the results screen, the dates match.
The value in the resultant column is the date being applied (not the defaulted date displaying at top) verified by the calculated values and manually entering the dates.
Best answer by lauraj46View original