topic How to get Date and Time as seperate fields from UNIX timestamp field? in App Development https://community.qlik.com/t5/App-Development/How-to-get-Date-and-Time-as-seperate-fields-from-UNIX-timestamp/m-p/1413379#M33318 <HTML><HEAD></HEAD><BODY><P>Hello there,</P><P></P><P>I have a UNIX timestamp format field.</P><P></P><P>The field is called Unix</P><P></P><P>An example value is this: 1499367403</P><P></P><P>How can I create two fields, one with the date, and the other containing the time? It should be in GMT+1 timezone.</P></BODY></HTML> Fri, 03 Nov 2017 20:02:41 GMT jblomqvist 2017-11-03T20:02:41Z How to get Date and Time as seperate fields from UNIX timestamp field? https://community.qlik.com/t5/App-Development/How-to-get-Date-and-Time-as-seperate-fields-from-UNIX-timestamp/m-p/1413379#M33318 <HTML><HEAD></HEAD><BODY><P>Hello there,</P><P></P><P>I have a UNIX timestamp format field.</P><P></P><P>The field is called Unix</P><P></P><P>An example value is this: 1499367403</P><P></P><P>How can I create two fields, one with the date, and the other containing the time? It should be in GMT+1 timezone.</P></BODY></HTML> Fri, 03 Nov 2017 20:02:41 GMT https://community.qlik.com/t5/App-Development/How-to-get-Date-and-Time-as-seperate-fields-from-UNIX-timestamp/m-p/1413379#M33318 jblomqvist 2017-11-03T20:02:41Z Re: How to get Date and Time as seperate fields from UNIX timestamp field? https://community.qlik.com/t5/App-Development/How-to-get-Date-and-Time-as-seperate-fields-from-UNIX-timestamp/m-p/1413380#M33319 <HTML><HEAD></HEAD><BODY><P>This thread should help you a lot: <A __default_attr="2517" __jive_macro_name="idea" class="jive_macro jive_macro_idea" data-orig-content="Convert Unix Timestamp" href="https://community.qlik.com/"></A></P></BODY></HTML> Sat, 04 Nov 2017 06:58:10 GMT https://community.qlik.com/t5/App-Development/How-to-get-Date-and-Time-as-seperate-fields-from-UNIX-timestamp/m-p/1413380#M33319 petter 2017-11-04T06:58:10Z