Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: converting YYYYMMDD to MMDDYYYY Post Reply Post New Topic
Author Message
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Topic: converting YYYYMMDD to MMDDYYYY
    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.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
 
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.051 seconds.