Print Page | Close Window

Crystal 9: format date within formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5240
Printed Date: 04 May 2024 at 1:35am


Topic: Crystal 9: format date within formula
Posted By: psfin_mn
Subject: Crystal 9: format date within formula
Date Posted: 16 Jan 2009 at 8:10am
I have an IF THEN formula on a Crystal 9 form to put together multiple fields.  (for PeopleSoft Financials, on an Oracle 10g database)  
I'm trying to get a date to display in the DD/MM/YYYY  format, but I cannot seem to find the correct solution... 
 
If I just have     +  ToText({APY2021.PAY_DOC_DT}) 
within the formula, it prints like 
Tuesday, 30 September, 2008
 
If I have      +  ToText({APY2021.PAY_DOC_DT}, 'DD/MM/YYYY' ) 
then is prints like 
DD/09/YYYY
 
 
What did I use in this formula so that this date piece prints properly in the DD/MM/YYYY format? 


Replies:
Posted By: DBlank
Date Posted: 16 Jan 2009 at 8:46am
ToText({APY2021.PAY_DOC_DT}, "dd/MM/yyyy" ) 

Posted By: psfin_mn
Date Posted: 16 Jan 2009 at 9:06am
aaahhh  -- Did not realize that it's case sensitive. 
Got it working. 
THANK YOU!


Print Page | Close Window