Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Resolved by replacing the T
Date#(Replace([Datefield],'T',' '),'YYYY-MM-DD hh:mm:ss') as Datefield,
Resolved by replacing the T
Date#(Replace([Datefield],'T',' '),'YYYY-MM-DD hh:mm:ss') as Datefield,