topic Re: Datetime format in QlikView https://community.qlik.com/t5/QlikView/Datetime-format/m-p/688670#M673583 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try with Timestamp() and Timestamp#()</P><P></P><P>Like,</P><P><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Timestamp(</SPAN><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; color: #800000;">DateField</SPAN><SPAN style="font-weight: inherit; font-style: inherit;">, 'YYYY-MM-DD hh:mm:ss.fff')</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 10pt; font-style: inherit; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-weight: inherit;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 10pt; font-style: inherit; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-weight: inherit;">Regards<BR /></SPAN></P></BODY></HTML> Fri, 15 Aug 2014 16:28:45 GMT PrashantSangle 2014-08-15T16:28:45Z Datetime format https://community.qlik.com/t5/QlikView/Datetime-format/m-p/688668#M673581 <HTML><HEAD></HEAD><BODY><P>In my Load script,</P><P></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Modified_Date</SPAN><SPAN style="font-size: 8pt;">, 'YYYY-MM-DD hh:mm:ss') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Modified_Date&nbsp; </SPAN></P><P></P><P></P><P>gets me the value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014-08-12 16:03:31</P><P>but I need&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014-08-12 16:03:31.643</P><P></P><P><SPAN style="color: #575757; font-size: 10pt;">I would appreciate help...</SPAN></P><P> </P><P><SPAN style="color: #575757; font-size: 10pt;">Thanks</SPAN></P><P> </P><P></P></BODY></HTML> Fri, 15 Aug 2014 16:16:54 GMT https://community.qlik.com/t5/QlikView/Datetime-format/m-p/688668#M673581 2014-08-15T16:16:54Z Re: Datetime format https://community.qlik.com/t5/QlikView/Datetime-format/m-p/688669#M673582 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3d3d3d; font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Original field is a datetime/timestamp: date(</SPAN><SPAN style="font-size: 10pt;"><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Modified_Date</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">, 'YYYY-MM-DD hh:mm:ss.fff') </SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">as</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> </SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Modified_Date </SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Original field is a text value: tetime/timestamp: </SPAN>date#(</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Modified_Date</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">, 'YYYY-MM-DD hh:mm:ss.fff') </SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">as</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> </SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Modified_Date </SPAN></SPAN></P></BODY></HTML> Fri, 15 Aug 2014 16:24:06 GMT https://community.qlik.com/t5/QlikView/Datetime-format/m-p/688669#M673582 Gysbert_Wassenaar 2014-08-15T16:24:06Z Re: Datetime format https://community.qlik.com/t5/QlikView/Datetime-format/m-p/688670#M673583 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try with Timestamp() and Timestamp#()</P><P></P><P>Like,</P><P><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Timestamp(</SPAN><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; color: #800000;">DateField</SPAN><SPAN style="font-weight: inherit; font-style: inherit;">, 'YYYY-MM-DD hh:mm:ss.fff')</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 10pt; font-style: inherit; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-weight: inherit;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 10pt; font-style: inherit; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-weight: inherit;">Regards<BR /></SPAN></P></BODY></HTML> Fri, 15 Aug 2014 16:28:45 GMT https://community.qlik.com/t5/QlikView/Datetime-format/m-p/688670#M673583 PrashantSangle 2014-08-15T16:28:45Z