1 Reply Latest reply: Nov 16, 2016 4:24 AM by Svein Ola Gundhus RSS

    string datetime issue, qw version issue?

    Svein Ola Gundhus

      Hi

      I have a local installation QV 12 and on the server I have 11.2.

      Both installations have the QvRestConnector.exe (64) and Imn using this to query a API.

       

      Datetime format returned is like this:  'YYYY-MM-DDThh:mm:ss'

       

      My version 12 reads this as a datetime stamp adn i can extract the date using Date#([Datefield])

       

      My version 11.2 reads this as text and Im struggeling converting this string to a numeric date

      I have tried several suggestions from this community but never seen any with the T separator between date and time.

       

      I try to do the conversion in the load statement:

       

      LOAD

      Date#([DateField],'YYYY-MM-DDThh:mm:ss') as DateField,

      This is not working.

       

      Any suggestions are much obliged.

       

      Thank you