2 Replies Latest reply: May 27, 2011 8:09 AM by patrice GARCIA RSS

    Difference between Timestamp and Timestamp#

    patrice GARCIA

      Hello

       

      I'm new with QlickView, and I trie to load a field from CSV file. The field is under the format 'DD/MM/YYYY mm:hh'

      What the difference with timestamp(XX) and timestamp#(XX) in the script to load file ?

      The result is different, when I trie to compar date loaded with date of the day

      Thank for the response

      P

        • Difference between Timestamp and Timestamp#
          Martina Brenner

          Hi,

           

          Timestamp#() means, that QV interpret the format from the source like you need, p.e.

           

          Timestamp#('20110512 08:22','YYYYMMDD hh:mm') As Timestamp or

           

          Timestamp#('05-12-2011 08.22:32','MM-DD-YYYY hh.mm.ss') As Timestamp

           

          And Timestamp() means the default format you wish to be shown in your application

           

          Timestamp('12-05-2011 08:22','DD.MM.YYYY hh:mm') As Timestamp

           

          often you need to combine both functions

           

          Timestamp(Timestamp#('20110512 08:22','YYYYMMDD hh:mm'),'DD.MM.YYYY hh:mm') As Timestamp

            • Re: Difference between Timestamp and Timestamp#
              patrice GARCIA

              Hi

              Thanks for the response

              In complement, if in my script, I have

               

               

              SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

              ...

              LOAD

              ..

                   Timestamp#([Heure d'ouverture]) as [Open_Incident],

               

               

              In a Chart Objet, the  expression : count({1<Open_Incident={">=$(=MonthStart(AddMonths(now(2),-3)))"}>}[ID Incident]) return datas

               

              When I have

                   Timestamp#([Heure d'ouverture],'DD/MM/YYYY hh:mm') as [Open_Incident],

               

              In a Chart Objet, the  expression : count({1<Open_Incident={">=$(=MonthStart(AddMonths(now(2),-3)))"}>}[ID Incident]) return non data

               

              Can you explain why ?

              Thanks

              P