Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date format 2020-06-30T07:01:50:000Z and want to convert it to a normal date-time format.
May be try like below
=timestamp(Timestamp#(left('2020-06-30T07:01:50:000Z',19) , 'YYYY-MM-DDThh:mm:ss'),'YYYY-MM-DD hh:mm:ss')