Forum Discussion
amirabedhiafi
Impactful Individual
Impactful IndividualFormat Date from text
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 = ...
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")
amitchandak
Super User
Super UserCreate 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")