Change Date format in field from YYYY/MM/DD to DD/MM/YYYY

[Former Member]

Newbie here,

I'm using Max CRM and Reporting with Crystal but when I pull a date field from max it is displaying the date as YYYY.MM.DD and I need it to be dd/MM/YYYY(23 January 2014) but it seems like Crystal is not seeing it as a date. I have tried a few formulas but no luck. Is there a way for me toresolve this?

P.S. The date field from Crystal itself displays the correct date format needed as I have used it for report created:

[raghavendra_hullur · Accepted solution]

Hi Jared,

Is your date field always comes in the format YYYY.MM.DD?

If you are looking for conversion of string to date, you can try below steps:

Create a formula with below content on your database field (assuming it is coming as a string):

numberVar d := toNumber(right({database field}, 2));

numberVar m := toNumber(mid({database field}, 6,2));

numberVar y := toNumber(left({database field}, 4));

cDate(y, m, d)

Use this formula instead of the date field and use format field option to change it required date format since the output of the formula content will be a date.

Hope this helps.

Thanks,

Raghavendra

[Former Member · Accepted solution]

Thanks!

Worked perfectly!