Print Page | Close Window

Group and Sort by VarChar Date 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=22240 Printed Date: 01 May 2024 at 9:11pm Topic: Group and Sort by VarChar Date Posted By: Cervello Subject: Group and Sort by VarChar Date Date Posted: 16 Feb 2017 at 4:31am I am trying to group and sort by a varchar date that has an erratic format such as this: Hire Date 1/1/2016 12/5/2016 11/12/2016 2/12/2016 Any help would be greatly appreciated. I was thinking of creating formula fields and they sort on those....but don't know if that would work. Replies: Posted By: DBlank Date Posted: 16 Feb 2017 at 6:39am I would convert it to a date data type and use that result for sorting and/or grouping date(table.field) Posted By: Cervello Date Posted: 16 Feb 2017 at 7:48am Thank you...I was definately complicating it :).

Print Page | Close Window