Crystal Reports String to Date Formula help! (yyyy-mm-dd)

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: String to Date Formula help! (yyyy-mm-dd)

Author	Message
pnut78 Newbie Joined: 13 Nov 2009 Location: United States Online Status: Offline Posts: 9	Topic: String to Date Formula help! (yyyy-mm-dd) Posted: 08 Oct 2018 at 9:41am
	Hello, For some reason, Crystal Reports 2016 is viewing a date field in my database table as a string field. I need to group by month so I need to make a formula to convert the string field that is in yyyy-mm-dd format to date.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 08 Oct 2018 at 11:23am
	You should be able to create a formula field as DATE(table.field) to convert it.
	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.047 seconds.