Hi All,

I have some JSON being received that includes a date and a time in the following format:

Date : '2020-09-14'
Time : '16:45:00'

How do I convert these to assign the value to a dataset column (of DataType dtDate and dtTime).

Thanks for any help,
Paul

Paul

Tim's framework (EWB) specifies that Date, Time, and DateTime needs to be a single integer in Unix time number of milliseconds.... see JSON reference in manual.

So if you are getting data and time in another format as you indicate, you will need to load into a field that is a string and do your own convertion into another field OnLoad.

As least that is what  I would do.

Date : '2020-09-14'
Time : '16:45:00'

Parse the fields and use EncodeDate and EncodeTime....

Walter

Thanks Walter. I used what you suggested and got it working with a little help from Tim.

Cheers,
Paul


Walter Matte wrote:

Paul

Tim's framework (EWB) specifies that Date, Time, and DateTime needs to be a single integer in Unix time number of milliseconds.... see JSON reference in manual.

So if you are getting data and time in another format as you indicate, you will need to load into a field that is a string and do your own convertion into another field OnLoad.

As least that is what  I would do.

Date : '2020-09-14'
Time : '16:45:00'

Parse the fields and use EncodeDate and EncodeTime....

Walter