Print Page | Close Window

converting YYYYMMDD to MMDDYYYY

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19191
Printed Date: 16 Apr 2024 at 12:38pm


Topic: converting YYYYMMDD to MMDDYYYY
Posted By: guy723
Subject: converting YYYYMMDD to MMDDYYYY
Date Posted: 28 Feb 2013 at 5:58am

Change Date String from YYYYMMDD to MMDDYYYY

please help.
 
P.S. can not change in editing format date tap.


Replies:
Posted By: hilfy
Date Posted: 01 Mar 2013 at 3:18am
In a formula you can use:  ToText({datefield}, 'MMddyyyy')
 
To Format the field without a formula:
 
1.  Right-click on the date and select Format...
2.  On the Date tab, click on the Customize button.
3.  Under "Format", change the Month and Day to have leading 0's.
4.  Under "Order", select "MDY".
5.  Under "Separators", change First and Second to "none".
 
-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