Date field 10/25/2020 how to change 25/10/2020 ?

[admin11]

Hi All

My date field format is 

10/25/2020 how to change 25/10/2020 

Hope some one can advise me.

Paul

[themistoklis · Accepted solution]

@admin11 

Using DAX formula try the following:

New Column = MID(TableName[AR Invoice Date],4,2) &"/"& LEFT(TableName[AR Invoice Date],2) & "/" & RIGHT(TableName[AR Invoice Date],4)

[admin11]

@themistoklis 

tHANK YOU VERY MUCH