Date format in formula field in Crystal report

Sailee Govekar
Sailee Govekar used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Hi,
Use attached report.
PurchasingExportAnalysisTabReport.rpt

Author

Commented:
Hi Raghvendra,

The .rpt file you gave is the exact format I required, but it retrieves some junk value.

Please check below image:
AnalysisError1.jpg

Commented:
Can you confirm what's the year value you have for those 2 junk ones?

Update: Forget it, I have those details in the report you shared. I will check that.

Commented:
The ones with junk value are having blank dates. Do you want to display it as a blank or some fixed date in those cases?

Author

Commented:
If it is blank then nothing to be shown.

Only the country name will come
Commented:
This will do.
Check it if you need any further changes.
PurchasingExportAnalysisTabReport.rpt

Author

Commented:
Working successfully

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial