topic Re: date format in QlikView https://community.qlik.com/t5/QlikView/date-format/m-p/477199#M178238 <HTML><HEAD></HEAD><BODY><P>year(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P>month(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P>week(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P>hour(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P>minute(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P>second(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P></P><P>If your timestamp is already a numeric timestamp and not a string then you don't need the timestamp# function, but can use the year, month, ...etc functions directly on the field: year(MyTimeStampField) etc</P></BODY></HTML> Thu, 08 Aug 2013 13:12:46 GMT Gysbert_Wassenaar 2013-08-08T13:12:46Z date format https://community.qlik.com/t5/QlikView/date-format/m-p/477198#M178237 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i want year,month,week and hrs,second from following date format....</P><P>is it possible to get all this from following date format.</P><P></P><P></P><P>ex...</P><P></P><P>2013.01.08 01:15:20</P></BODY></HTML> Thu, 08 Aug 2013 13:07:29 GMT https://community.qlik.com/t5/QlikView/date-format/m-p/477198#M178237 2013-08-08T13:07:29Z Re: date format https://community.qlik.com/t5/QlikView/date-format/m-p/477199#M178238 <HTML><HEAD></HEAD><BODY><P>year(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P>month(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P>week(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P>hour(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P>minute(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P>second(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))</P><P></P><P>If your timestamp is already a numeric timestamp and not a string then you don't need the timestamp# function, but can use the year, month, ...etc functions directly on the field: year(MyTimeStampField) etc</P></BODY></HTML> Thu, 08 Aug 2013 13:12:46 GMT https://community.qlik.com/t5/QlikView/date-format/m-p/477199#M178238 Gysbert_Wassenaar 2013-08-08T13:12:46Z Re: date format https://community.qlik.com/t5/QlikView/date-format/m-p/477200#M178239 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using </P><P>year(('Date_Time')<SPAN style="text-decoration: underline;">YYYY.DD.MM hh:mm:ss) as year</SPAN></P><P></P><P>but i am getting error on above underline portion....</P></BODY></HTML> Fri, 09 Aug 2013 05:11:17 GMT https://community.qlik.com/t5/QlikView/date-format/m-p/477200#M178239 2013-08-09T05:11:17Z Re: date format https://community.qlik.com/t5/QlikView/date-format/m-p/477201#M178240 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i solved problem</P></BODY></HTML> Fri, 09 Aug 2013 07:45:31 GMT https://community.qlik.com/t5/QlikView/date-format/m-p/477201#M178240 2013-08-09T07:45:31Z