topic Re: European time zone when converting ldap field in QlikView https://community.qlik.com/t5/QlikView/European-time-zone-when-converting-ldap-field/m-p/1262309#M868151 <HTML><HEAD></HEAD><BODY><P>Found out myself <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" />:</P><P>timestamp((left(lastLogon,11)/86400-109205)+time#('01:00:00','hh:mm:ss'),'YYYY-MM-DD hh:mm:ss') as ADLastlogon</P></BODY></HTML> Thu, 01 Dec 2016 12:56:34 GMT ingridmerx 2016-12-01T12:56:34Z European time zone when converting ldap field https://community.qlik.com/t5/QlikView/European-time-zone-when-converting-ldap-field/m-p/1262308#M868150 <HTML><HEAD></HEAD><BODY><P>In my load script I converted an LDAP field, but it shows the UTC time. To be in European (Amsterdam) time it should be minus one hour. What is the best way to achieve this?</P><P>I used:</P><P>timestamp(left(lastLogon,11)/86400-109205)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/European-time-zone-when-converting-ldap-field/m-p/1262308#M868150 ingridmerx 2020-11-25T16:16:04Z Re: European time zone when converting ldap field https://community.qlik.com/t5/QlikView/European-time-zone-when-converting-ldap-field/m-p/1262309#M868151 <HTML><HEAD></HEAD><BODY><P>Found out myself <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" />:</P><P>timestamp((left(lastLogon,11)/86400-109205)+time#('01:00:00','hh:mm:ss'),'YYYY-MM-DD hh:mm:ss') as ADLastlogon</P></BODY></HTML> Thu, 01 Dec 2016 12:56:34 GMT https://community.qlik.com/t5/QlikView/European-time-zone-when-converting-ldap-field/m-p/1262309#M868151 ingridmerx 2016-12-01T12:56:34Z