Print Page | Close Window

Convert Date

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=13938
Printed Date: 20 Apr 2025 at 12:01pm


Topic: Convert Date
Posted By: pjgreports
Subject: Convert Date
Date Posted: 01 Aug 2011 at 11:19am
I have a field {PAUDIT.DATE} in my report that brings the date displayed as YYYYMMDD.  example: 20110601.  I need to convert date to 06/01/2011/ .  I have tried using CDATE function but i am having no luck unless i am doing something wrong here.  Can anyone help ?


Replies:
Posted By: hilfy
Date Posted: 02 Aug 2011 at 7:26am
Try this:
 
If not IsNull({PAUDIT.DATE}) and {PAUDIT.DATE} <> '' then
Date(ToNumber(left({PAUDIT.DATE}, 4)), ToNumber(mid({PAUDIT.DATE}, 5, 2)), ToNumber(right({PAUDIT.DATE, 2})))
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window