Using Sage 2022 on Windows 2019 server.
I am facing a problem with running PJC canned reports in Intelligence reporting. This is with the dates in the filter screen that comes up as soon as I run the report. Please note that I am using European date formats.
Description : [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string.
Number : -2147217913
Driver Error : 241
SQL State : 22008
The problem is with two main reports, PJC Profit Analysis and PJC Detailed costs that reference dates in the format of 01 August 2022
Other reports such as PJC Transaction History that reference dates in the same format, run just fine.
I tried playing around with the configuration on Long date with no success.