string datetime issue, qw version issue?

[#1]

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

[#2 · Accepted solution]

Resolved by replacing the T

Date#(Replace([Datefield],'T',' '),'YYYY-MM-DD hh:mm:ss') as Datefield,