Posting UTC datetime Value

[Randall_Ken (Ken Randall)]

Hi,

I am posting a new record. The json is as follows:

{
	"BranchRef": "CRO",
	"Comments": "Follow-up.",
	"ContactMethod": 3,
	"ContactReason": 1,
	"DateTime": "2023-04-19T13:10:53.653Z",
	"GUID": "61b3af3b-9f9c-1215-5e30-74cccad2152f",
	"HouseGUID": "ed9985bc-3fff-42f1-a791-2b3a9c3eb90f",
	"Initials": "KC"
}

But I am getting the error Invalid TDateTime JSON value at $.DateTime. What is wrong with the DateTime I am sending?

Displaying the data works fine. Just seems to be a problem with the post!

Thanks,

Ken

[wlandgraf (Wagner Landgraf)]

Please refer to:

TDateTime Field throws TJsonTypeConverter.EConvertFromJsonError when providing ISODateString

By default, XData doesn't process ISO dates with time zone. It raises an error. You can change that by setting a global parameter to tell how XData should process the time zone: uses Bcl.Utils; DefaultTimeZoneMode := TTimeZoneMode.AsLocal; The above will tell XData to interpret all dates with time zones and convert them to local time zone.

And:

Date format issues with MariaDb

By default, ISOToDateTime doesn't accept time zones. There is an overload method that you can pass the TTimeZoneMode, which you specify how time zone must be treated: class function ISOToDateTime(const Value: string; TimeZoneMode: TTimeZoneMode): TDateTime; overload; TTimeZoneMode = (Error, Ignore, AsUTC, AsLocal); Default is Error, which means if the date has timezone information, a error will be raised. You can use any of the other options: Ignore will simply strip out the time zone and ig…

[Randall_Ken (Ken Randall)]

Many thanks.