toDateTime bug?

Hi.

I was attempting to use the toDateTime function.

In its documentation it says

When i enter the expression from the above:

I get back the following

Why is this?

Brainy

Your result output is converting the GMT value back to your local time zone (note the documentation it says the value will be GMT).

Thus, "1/22/2014" at midnight GMT, would be displayed as 1/21/2014 at 7 PM EST.

The Expression Guru

Sign up