0 Replies Latest reply: Dec 6, 2017 10:09 AM by Jonnie Yacoub RSS

    Convert Google Analytics date

    Jonnie Yacoub

      hi Qlikerss,

       

      I have made an connection with Google Analytics and imported some files. and i have the following field:

      dim_dateHourMinute as [DataFromQueryURI.dim_dateHourMinute]

       

      as you can see the field is yyyymmddhhmm... (for example 201708031353) I want to convert this to dd/mm/yyyy. so i can use it in a drill down dimension (year>month>day).

       

      tried this so far without result:

      date(date#(dim_dateHourMinute,'yyyymmddhhmm'),'DD/MM/YYYY') as [DataFromQueryURI.dim_dateHourMinute],

       

      Thanks