Formula to convert American Date Format to European Style?

Question

I have a field (Quote_Date__c) that shows the date in American style: (10/22/2019)

I am creating a new formula field (text) to convert the date to: 22/10/2019

This is the formula that I've used:

text(DAY(Quote_Date__c() )) +'/'+ text(MONTH(Quote_Date__c() )) +'/'+ text(YEAR(Quote_Date__c() ))

But I'm getting syntax error.

Any idea what's wrong with my formula please?

Deepak K Anand · Accepted Answer

Try this = LPAD(TEXT(DAY(Quote_Date__c)),   2, "0") + "/" + LPAD(TEXT(MONTH(Quote_Date__c)), 2, "0") + "/" + TEXT(YEAR(Quote_Date__c))

Deepak K Anand · Answer

Because you wrote the fields like this = Quote_Date__c()  and you need the ()

We made a wrong turn. Try again.