Print Page | Close Window

Dates from SQL db Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Technical Questions Forum Discription: Formulas, charting data, Crystal syntax, etc. URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22563 Printed Date: 27 Apr 2024 at 7:46pm Topic: Dates from SQL db Posted By: Macavity Subject: Dates from SQL db Date Posted: 22 Mar 2018 at 4:45am Hi, I have a report with an SQL db datasource with date types DATE, these show in the report as strings instead of dates.  How can I solve this without having to use formulas ? Thank you Replies: Posted By: kevlray Date Posted: 22 Mar 2018 at 11:04am When you say SQL db are you meaning MS-SQL db?  If so, I have never seen this behavior.  What version of Crystal Reports are you using and what is the version of the DB and how are you connecting to the DB? Posted By: DBlank Date Posted: 23 Mar 2018 at 2:31am I usually cast them to Datetime in the select criteria

Print Page | Close Window