topic How to convert gulf standard datetime to standard datetime format ? in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-gulf-standard-datetime-to-standard-datetime/m-p/871760#M1014114 <HTML><HEAD></HEAD><BODY><P>I want to convert gst date time to a standard date time. Like 2015-03-24T10:43:46.000Z is gst i want it in standard date time format like 2015-03-24 10:43:46. I'm unable to do that.</P></BODY></HTML> Tue, 21 Apr 2015 06:55:30 GMT skr002244 2015-04-21T06:55:30Z How to convert gulf standard datetime to standard datetime format ? https://community.qlik.com/t5/QlikView/How-to-convert-gulf-standard-datetime-to-standard-datetime/m-p/871760#M1014114 <HTML><HEAD></HEAD><BODY><P>I want to convert gst date time to a standard date time. Like 2015-03-24T10:43:46.000Z is gst i want it in standard date time format like 2015-03-24 10:43:46. I'm unable to do that.</P></BODY></HTML> Tue, 21 Apr 2015 06:55:30 GMT https://community.qlik.com/t5/QlikView/How-to-convert-gulf-standard-datetime-to-standard-datetime/m-p/871760#M1014114 skr002244 2015-04-21T06:55:30Z Re: How to convert gulf standard datetime to standard datetime format ? https://community.qlik.com/t5/QlikView/How-to-convert-gulf-standard-datetime-to-standard-datetime/m-p/871761#M1014115 <HTML><HEAD></HEAD><BODY><P>Try Date(PurgeChar([Date],'TZ') ,'YYYY-MM-DD hh:mm:ss')</P></BODY></HTML> Tue, 21 Apr 2015 06:59:10 GMT https://community.qlik.com/t5/QlikView/How-to-convert-gulf-standard-datetime-to-standard-datetime/m-p/871761#M1014115 fvelascog72 2015-04-21T06:59:10Z