Expand my Community achievements bar.

SOLVED

Behavior of Date Time field when fetched in JavaScript using Query Def

Avatar

Level 7

Hello Folks,

I am trying to fetch a date time field from the Additional Data of Query activity in JS. I am using a queryDef for doing the same. But however i observed weird thing that value fetched is not same.

I am trying to fetch Event Date from the delivery schema for a particular delivery and value is 1/31/2019 05:58:45 AM. However if i log the same in JS after fetching it. I am seeing it as 2019-01-31 10:58:45.059Z. It is coming in different pattern (i can change it later) and with time zone (i can truncate it). But look at the time it is 10:58:45 instead of 05:58:45

I tried with today's date too, instead of showing 2/19/2019 02:54:51 AM it is showing as 2019-02-19 07:54:51.547Z.

Would like to understand what is happening behind the scenes. Is it something to do with Time zone set in workflow properties?

Regards,

Sri Bhargav

1 Accepted Solution

Avatar

Correct answer by
Level 7
3 Replies

Avatar

Level 7

Folks, Could someone please provide any pointers on this

Regards,

Sri Bhargav

Avatar

Community Advisor

the parser is just different when you're using javascript or an extract/delivery

Re: How to display date and time in UTC format i.e, 2018-05-02T13:47:33.743Z?

You have to play with newDate function options to match the date



David Kangni

Avatar

Correct answer by
Level 7

Thank you David!