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.

Sailee GovekarStudentAsked:
Who is Participating?
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:
Use attached report.
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:
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.
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

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

Only the country name will come
Raghavendra HullurSoftware DeveloperCommented:
This will do.
Check it if you need any further changes.

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
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.