Date Problem with 12.5 SQL

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Terry_Carter
Posts: 10
Joined: Tue Oct 10, 2017 12:44 pm

Date Problem with 12.5 SQL

Post by Terry_Carter » Mon Dec 14, 2015 10:09 am

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

Chris_Strasser_(Guest)
Posts: 47
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Date Problem with 12.5 SQL

Post by Chris_Strasser_(Guest) » Thu Jan 21, 2016 1:15 pm

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?

Post Reply