Error when converting from date/time to date

[jagostinhoCT]

Hi

Getting an error while trying to convert from date/time to date

The original date format is

MM/DD/YYYY HH:MM

and I want to have just DD/MM/YYYY.

the original date is being pulled from a file in a sharepoint folder.

Maybe the source is formated as US locale?

I want to use the UK locale instead.

Thanks

[v-chuncz-msft · Accepted solution]

@jagostinhoCT,

You may add a custom column as follows.

DateTime.ToText(DateTime.From([Date created]), "dd/MM/yyyy")