Page 1 of 1

Date Problem with 12.5 SQL

Posted: Mon Dec 14, 2015 10:09 am
by Terry_Carter
Running any report on the server works as expected. When running the same reports from the client PC, it will not return any results if there is a date in filter. Date settings are identical on both the server and the client. Any pointers as what to look for

=> RE: Date Problem with 12.5 SQL

Posted: Thu Jan 21, 2016 1:15 pm
by Chris_Strasser_(Guest)
Is the ODBC driver the same version on both systems? Is it a DATE field or a DATETIME?____Are you hard-coding the date in the report or is it a parameter or calculated value?____Have you used a monitoring tool to see what^s happening to the query on the server?____Can you post the SQL that ReportWorks is generating here?