Crystal Reports Dates from SQL db

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Dates from SQL db

Author	Message
Macavity Groupie Joined: 24 Sep 2012 Online Status: Offline Posts: 93	Topic: Dates from SQL db 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
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	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?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 23 Mar 2018 at 2:31am
	I usually cast them to Datetime in the select criteria
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.