Print Page | Close Window

String to Date Formula help! (yyyy-mm-dd) Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22677 Printed Date: 29 Apr 2024 at 7:43am Topic: String to Date Formula help! (yyyy-mm-dd) Posted By: pnut78 Subject: String to Date Formula help! (yyyy-mm-dd) Date 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. Replies: Posted By: DBlank Date Posted: 08 Oct 2018 at 11:23am You should be able to create a formula field as DATE(table.field) to convert it.

Print Page | Close Window