Date Formatting Registration Date Column - Converting into same date format

[rastogi_vinayak]

 Please give me the idea how to convert registration column date format into same date formatted as "Date of Incident" column (DD-MM-YYYY)

Thanks in Advanced..!!

[JuanGerardo]

Try:

Date(Date#(RegistrationDate, 'M/D/YYYY'), 'DD-MM-YYYY')

JG

[rastogi_vinayak]

thanks for reply @JuanGerardo 

I try the same but it is not working 

Date(Date#("Claim Registration Date", 'MM/DD/YYYY'), 'DD-MM-YYYY') as "Claim Registration Date"

please suggest another expression.

[NitinK7]

can you attach here same data in excel file for those two fields only

[Vikash · Accepted solution]

Hi, 

Try : date("Claim Registration Date",'DD-MM-YYYY') as "Claim Registration Date"

Vik