Print Page | Close Window

DateTimeStamp Formatting

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=10388
Printed Date: 04 May 2024 at 7:06am


Topic: DateTimeStamp Formatting
Posted By: patil
Subject: DateTimeStamp Formatting
Date Posted: 29 Jun 2010 at 6:43pm
Hi All,
 
In my report DateTimestamp is a string datatype and the value for this is

2010-03-25 08:33:46.132

but i want this value in the format as specified:
03-25-2010 08:33:46.132
how to format this? because this field is already concatenated with date and time ... plz plz help me out ASAP 


Replies:
Posted By: Emir_W
Date Posted: 29 Jun 2010 at 10:23pm
- right click the field
- choose 'Format Field...'
- click 'Customize...'
- click 'Date' tab
- change the order as you wish..
 
 
hope it help.
 


-------------
Emir W


Print Page | Close Window