How to convert format field date from mm/dd/yy to other format in report

Business Central/NAV Developers Forum
1

How to convert date format in report from 03/28/2013 to a string like this 28 MAR 2013 ?

2

Try

FORMAT(TODAY,0,’<Day,2> <Month Text,3> ')

3

It worked.

If you don’t mind, i have another question.

My country have different format for month name, for example : JUNE in my country are JUNY.

What should i do to customize them ?

4

Have you choose proper Regional settings in your system?

I think it should take care of that…

5

I know it could. But If i want to make my own format regardless region, what should i do?