topic Loading a timestamp from csv file in QlikView https://community.qlik.com/t5/QlikView/Loading-a-timestamp-from-csv-file/m-p/151575#M29353 <HTML><HEAD></HEAD><BODY><P>I am trying to read a timestamp from a csv</P><P>blobname, unitblobname. ,blabla,N,Combustion Turbine,<STRONG>09/01/2009 5:00 PM</STRONG>,MV90 Hourly,0.0</P><P></P><P>I deifned the timestmap format as MM/DD/YYYY h:mm a, but when I run the Load script, the pivot chart I use to display the dates fails to show me values. This chart has calculated dimension base don the timestamp parameter such as year(timestamp), day(timestamp), month(timestamp)</P><P></P><P>Is there a better way to Load timestamp data from a csv file?</P></BODY></HTML> Sat, 14 Nov 2009 00:19:05 GMT 2009-11-14T00:19:05Z Loading a timestamp from csv file https://community.qlik.com/t5/QlikView/Loading-a-timestamp-from-csv-file/m-p/151575#M29353 <HTML><HEAD></HEAD><BODY><P>I am trying to read a timestamp from a csv</P><P>blobname, unitblobname. ,blabla,N,Combustion Turbine,<STRONG>09/01/2009 5:00 PM</STRONG>,MV90 Hourly,0.0</P><P></P><P>I deifned the timestmap format as MM/DD/YYYY h:mm a, but when I run the Load script, the pivot chart I use to display the dates fails to show me values. This chart has calculated dimension base don the timestamp parameter such as year(timestamp), day(timestamp), month(timestamp)</P><P></P><P>Is there a better way to Load timestamp data from a csv file?</P></BODY></HTML> Sat, 14 Nov 2009 00:19:05 GMT https://community.qlik.com/t5/QlikView/Loading-a-timestamp-from-csv-file/m-p/151575#M29353 2009-11-14T00:19:05Z Loading a timestamp from csv file https://community.qlik.com/t5/QlikView/Loading-a-timestamp-from-csv-file/m-p/151576#M29354 <HTML><HEAD></HEAD><BODY><P>Youmay use the timestamp#() function if you didn't do it before. Use</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">timestamp#(FieldName,'MM/DD/YYYY h:mm')</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope it helps!</P></BODY></HTML> Sat, 14 Nov 2009 00:28:47 GMT https://community.qlik.com/t5/QlikView/Loading-a-timestamp-from-csv-file/m-p/151576#M29354 Miguel_Angel_Baeyens 2009-11-14T00:28:47Z Loading a timestamp from csv file https://community.qlik.com/t5/QlikView/Loading-a-timestamp-from-csv-file/m-p/151577#M29355 <HTML><HEAD></HEAD><BODY><P>Need to use "tt" for AM/PM, not "a":</P><P style="padding-left:30px;">timestamp#(FieldName,'MM/DD/YYYY h:mm tt')</P></BODY></HTML> Sat, 14 Nov 2009 00:41:32 GMT https://community.qlik.com/t5/QlikView/Loading-a-timestamp-from-csv-file/m-p/151577#M29355 johnw 2009-11-14T00:41:32Z