Format Date from text

[amirabedhiafi]

I have the following date stored in this format as text : 

publishedAt : 2021-04-02T04:13:55Z

I want to have two columns with these formats : 

publishedAtConv1 = 02/04/2020

publishedAtConv2 = 02/04/2020 04:13:55

[amitchandak · Accepted solution]

@amirabedhiafi ,

Create a date

Date = date(left([datetext],4),mid([datetext],6,2),,mid([datetext],9,2))

Datetime  = date(left([datetext],4),mid([datetext],6,2),,mid([datetext],9,2)) & time(mid([datetext],12,2),mid([datetext],15,2) ,mid([datetext],18,2))

From column tools, you can choose format. if you want to text again

Datetime text = format([Datetime], "dd/mm/yyyy hh:mm:ss")