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
Sailee GovekarStudentAsked:
Who is Participating?
 
Raghavendra HullurSoftware DeveloperCommented:
This will do.
Check it if you need any further changes.
PurchasingExportAnalysisTabReport.rpt
1
 
Raghavendra HullurSoftware DeveloperCommented:
Hi,
Use attached report.
PurchasingExportAnalysisTabReport.rpt
0
 
Sailee GovekarStudentAuthor 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
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Raghavendra HullurSoftware DeveloperCommented:
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.
0
 
Raghavendra HullurSoftware DeveloperCommented:
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?
0
 
Sailee GovekarStudentAuthor Commented:
If it is blank then nothing to be shown.

Only the country name will come
0
 
Sailee GovekarStudentAuthor Commented:
Working successfully
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.