Forum Discussion
Format 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 = 02/04/2020 04:13:55
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")
1 Reply
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")