Datetime string with offset as 'Z' to Datetime Conversion.

[Former Member]

Hi,

I am trying to convert a string to Datetime using DateTime(). This string contains value as '2017-01-13Z'. When I try to convert this string to DateTime using conversion function DateTime('2017-01-13Z') it returns NULL value. I know Z represents Zero Offset in UTC.

When I am trying to convert a string contains '2017-01-12T' to Datetime using same method, it converts it to datetime successfully.

Strange is, the conversion returns datetime for one instance but fails for another instance. I am not sure if this is related to some datetime setting.

Please suggest.