Formate date

[Anonymous]

Hi,

How to change 03-30-2016 to 03/30/2016.

Thanks,

Krishna

[Chanty4u]

set Dateformat='MM/DD/YYYY';

[sunny_talwar]

May be this:

Date(Date#('03-30-2016', 'MM-DD-YYYY'), 'MM/DD/YYYY')

[Chanty4u]

or

date(Date#(datefield,'MM-DD-YYYY'),'MM/DD/YYYY') as newdate;

[clondono]

or if you want to format the date at the chart level, in the object properties select the number tab and check "Override Document Settings", highlight the date field.  Select date and enter the Format Pattern you are looking for (MM/DD/YYYY)

[agustinbobba]

Hi!,

Try this

DATE(MakeDate(YEAR(Date), MONTH(Date), DAY(MDate)),'DD/MM/YYYY')

Best regards!

Agustin

[MarcoWedel]

depends on where you see this source format.

Can you post a sample?

thanks

regards

Marco