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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

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
Raghavendra HullurSoftware DeveloperCommented:
This will do.
Check it if you need any further changes.
PurchasingExportAnalysisTabReport.rpt
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sailee GovekarStudentAuthor Commented:
Working successfully
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.