Skip to Content

Date format in formula field in Crystal report

How can I achieve the date in "DD MMM YYYY" format in formula field of Crystal report.


I have one formula, where I am concatenating the Country name with the Date.

It takes the system format when the report is generated.

How can I fix the format to "DD MMM YYYY"

Currently on my system is displaying "DD-MM-YY" and on my colleague's System is s displaying "mm/dd/yyyy"

Attached below is the image and the shareable link for the Crystal Report.

https://drive.google.com/open?id=1YHdKcGzXllrOV0-PHWZ7uxul0IELeBle

analysiserror.jpg (255.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 13, 2017 at 09:25 AM

    Hi Sailee,

    Modify the formula to:

    "Ex Works Country: " & {procPurch_Rpt_AnalysisQuotesBySuppliers;1.Ex Works Country} & " Valid Until: " & If Date({procPurch_Rpt_AnalysisQuotesBySuppliers;1.Valid Until}) <> cdate(0,0,0) then totext(Date({procPurch_Rpt_AnalysisQuotesBySuppliers;1.Valid Until}), 'dd MMM yyyy')

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 13, 2017 at 10:29 AM

    Thank you Abhilash it worked as per you suggested.

    Add comment
    10|10000 characters needed characters exceeded