http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19021 WebAug 20, 2003 · Crystal does not use to_char, so you could either create a SQL Expression (depending upon your Crystal version): Insert->Fioeld Object->Right click SQL Expression and select New, then add in: TO_CHAR(V_PIN_TRACK_MAPPING.ACTIVATED_DATE, 'MM/YYYY') Now you can use this field in the report as you might any other field.
[Solved] How to convert datetime format to date format in crystal
WebOct 7, 2024 · hi all expertise. i'm using build in crystal report in visual studio 2008, i want to set date in crystal report, now the date appear like this 12-02-2012 12:00:00AM. i need to display date only, trying so hard to find the way to change the format. but no luck so far..need help from expertise here. Tuesday, December 11, 2012 9:29 AM. WebKeywords. Convert Date to Number, Crystal Reports , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem. dmskin-cloudmusic
Crystal reports date field converted to datetime field - SAP
WebSep 28, 2010 · Online Status: Offline. Posts: 6. Topic: Convert Number to Date. Posted: 28 Sep 2010 at 5:49am. I am trying to convert a number field (integer) to a date field so I can sort on the date. In the original database it is a date entry but when I bring it to crystal for some reason it is a number field (such as 20,100,101 for Jan 1 2010. WebThe report option to convert a date time field to a date or a string no longer exits in Crystal Reports 9 and above, but if the report was created in an older version and this option was used, then it will honor the setting, and will display it in those reports. To modify the setting: Open the report in Crystal Reports. http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=16132 dms just thrive