How to convert date into DD/MM/YYYY

[P_Kale]

Hi,

I have date in below given format can you pl help to convert into DD/MM/YYYY.

I have tried through Date and Subfield function but it is not working.

Thanks in advance

@swuehl 

[vincent_ardiet_]

Try:
=Date(Date#(Left([DateFieldToBeConverted],10),'YYYY-MM-DD'),'DD/MMM/YY')

[P_Kale]

Hi,

Thanks but i have not got any output. It is blank.

[P_Kale · Accepted solution]

hI,

i have tried it different way and it is working.

date(Left(PTRNEFF,10),'DD/MM/YYYY') as PTRNEFF_1

Thanks