https://community.qlik.com/t5/App-Development/Change-date-field-format-from-Google-Analytics-API/m-p/1638124#M47797 <P>I've pulled in data in Qlik Sense (cloud) from the Google Analytics connector. I'm trying to convert the standard date [ga_dateHourMinute] field to a more eligible date format.</P><P>The current format is YearMonthDayhHourMinute, for instance: 201810250004, I would like to convert this to the standard date format 2018-10-25 00:04:00. How do I do this? Answers concerning methods in the data load script or master formula's or variables are all welcome.</P><P><A href="https://i.stack.imgur.com/1IQXR.png" target="_blank" rel="nofollow noopener noreferrer">Click to see screenshot</A><A href="https://www.talktowendys.website/" target="_self">:</A> left = current date format and right = desired date format</P> Wed, 23 Oct 2019 05:14:07 GMT Luke69857 2019-10-23T05:14:07Z https://community.qlik.com/t5/App-Development/Change-date-field-format-from-Google-Analytics-API/m-p/1638124#M47797 <P>I've pulled in data in Qlik Sense (cloud) from the Google Analytics connector. I'm trying to convert the standard date [ga_dateHourMinute] field to a more eligible date format.</P><P>The current format is YearMonthDayhHourMinute, for instance: 201810250004, I would like to convert this to the standard date format 2018-10-25 00:04:00. How do I do this? Answers concerning methods in the data load script or master formula's or variables are all welcome.</P><P><A href="https://i.stack.imgur.com/1IQXR.png" target="_blank" rel="nofollow noopener noreferrer">Click to see screenshot</A><A href="https://www.talktowendys.website/" target="_self">:</A> left = current date format and right = desired date format</P> Wed, 23 Oct 2019 05:14:07 GMT https://community.qlik.com/t5/App-Development/Change-date-field-format-from-Google-Analytics-API/m-p/1638124#M47797 Luke69857 2019-10-23T05:14:07Z