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

    string datetime issue, qw version issue?


      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:



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

      This is not working.


      Any suggestions are much obliged.


      Thank you