asked on

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

SOLUTION

Raghavendra Hullur

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sailee Govekar

ASKER

Hi Raghvendra,

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

Please check below image:

Raghavendra Hullur

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.

Raghavendra Hullur

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 Govekar

ASKER

If it is blank then nothing to be shown.

Only the country name will come

ASKER CERTIFIED SOLUTION

Raghavendra Hullur

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sailee Govekar

ASKER

Working successfully