Date convert into DD/MM/YYY

[bhavvibudagam]

Hi Experts,

Can any one please help me on below requirement.

I have a DATE Field like YYMMDD below. How to convert this field like DD/MM/YYYY  Please help me on this.

Thanks in advance.

[shiveshsingh · Accepted solution]

Hi

Use this

date(date#(DATE,'YYMMDD'),'DD/MM/YYYY')

[swuehl]

Have a look at

Get the Dates Right

Why don’t my dates work?

and also the referenced technical brief.