Qlik Community

Qlik Sense Cloud Discussions

jonnieyacoub
Contributor

Convert Google Analytics date

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