what is this date format 2020-06-30T07:01:50:000Z and how to convert

[qliklearnervir]

I have a date format 2020-06-30T07:01:50:000Z and want to convert it to a normal date-time format.

[MayilVahanan]

HI @qliklearnervir 

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')