topic Re: Re: Timestamp only showing half the time in QlikView https://community.qlik.com/t5/QlikView/Timestamp-only-showing-half-the-time/m-p/695163#M251297 <HTML><HEAD></HEAD><BODY><P>Thanks for your input.</P><P></P><P>I am already using the exact same code as you suggested in my script, but it still fails to display in some given timeframe.</P><P></P><P>It should perhaps be noted that in my <SPAN><SPAN style="text-decoration: underline;">application</SPAN> I use a text object with the expression =timestamp(Cur, 'DD.MM.YYYY - hh:mm:ss')</SPAN></P></BODY></HTML> Fri, 01 Aug 2014 07:43:20 GMT 2014-08-01T07:43:20Z Timestamp only showing half the time https://community.qlik.com/t5/QlikView/Timestamp-only-showing-half-the-time/m-p/695161#M251295 <HTML><HEAD></HEAD><BODY><P>Hey fellow QV'ers!</P><P></P><P>I am running an external bat script which creates a csv file with the timestamp and date of when the script was run.</P><P>I am then using this csv file in my QV script to display the time for when the bat script was last run.</P><P>Strangely enough it works about half of the time. The way I can tell something is wrong is by looking at my application and the time and date simply does not show. But I get no script errors so it is hard to track what is "wrong".</P><P></P><P>When I arrive work in the morning it does not display time and date, but around 10-11 in the morning it just starts displaying again until the workday is over. I have yet to find exact times for when it works and not, but there seems to be a pattern at least.</P><P></P><P>Anyone had any similar issues? I have checked my csv file both at times when it does display and not, and it looks the same (e.g. the timestamp is still there, even when it doesn't work).</P><P></P><P>The .csv file has the following format: MM/DD/YYYY hh:mm:ss</P><P>The publisher running the file is set to the same, but in my script I use a nested timestamp function in order to display it as DD.MM.YYYY - hh:mm:ss.</P><P></P><P>I am running out of ideas of why this only works half of the time, so I would be really grateful if anyone has any input as to what could be causing this. </P></BODY></HTML> Fri, 01 Aug 2014 06:38:52 GMT https://community.qlik.com/t5/QlikView/Timestamp-only-showing-half-the-time/m-p/695161#M251295 2014-08-01T06:38:52Z Re: Timestamp only showing half the time https://community.qlik.com/t5/QlikView/Timestamp-only-showing-half-the-time/m-p/695162#M251296 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I also had a same issue once and was ok after using below way.</P><P></P><P>(Timestamp(Timestamp#(<EM>INDEXED_DATE_TIME</EM>,'DD/MM/YYYY hh:mm:ss')),'MM/DD/YYYY hh:mm:ss')</P></BODY></HTML> Fri, 01 Aug 2014 07:34:18 GMT https://community.qlik.com/t5/QlikView/Timestamp-only-showing-half-the-time/m-p/695162#M251296 senarath 2014-08-01T07:34:18Z Re: Re: Timestamp only showing half the time https://community.qlik.com/t5/QlikView/Timestamp-only-showing-half-the-time/m-p/695163#M251297 <HTML><HEAD></HEAD><BODY><P>Thanks for your input.</P><P></P><P>I am already using the exact same code as you suggested in my script, but it still fails to display in some given timeframe.</P><P></P><P>It should perhaps be noted that in my <SPAN><SPAN style="text-decoration: underline;">application</SPAN> I use a text object with the expression =timestamp(Cur, 'DD.MM.YYYY - hh:mm:ss')</SPAN></P></BODY></HTML> Fri, 01 Aug 2014 07:43:20 GMT https://community.qlik.com/t5/QlikView/Timestamp-only-showing-half-the-time/m-p/695163#M251297 2014-08-01T07:43:20Z