Get offset from a date
hi all,
i have been trying to get offset in a date format. i m using
toLocaleDateTimeString({“timeZone”:$dealerTimeZone, “format”:“yyyy-MM-dd'T'HH:mm:ss Z”})
since Z denotes offset, but its not...
Forum Discussion
Thanks for the reply @bojanvelevski.
I think the issue may be that expressions are not allowed in the JSON Generator snap? The solution to my problem is easy enough, I’ll just put a mapper snap before my JSON Generator snap and use the “null-safe access” option to fill in the blanks where needed, but I am surprised this isn’t an option in the JSON Generator snap, and I’m also not sure if any expressions are allowed.
See the very basic chain-JSON Generator pipeline that demonstrates the problem. I can’t reference the input object with an $.get(“num”) expression.
Didn’t noticed that we are talking about JSON Generator snap. @viktor_n 's suggestion should work.
so is there any workaround to get this??
the Z indicates there is no time offset from GMT. Where do you want an offset from?
I think vipulk10 is using the Z per the joda DateTimeFormat per the URL referenced in the SnapLogic Documentation for toLocaleDateTimeString - DateTimeFormat (Joda-Time 2.11.1 API). If the SnapLogic method utilized the joda formatting entirely, the Z would result in the offset value “-0800”. While ‘Z’ (in single quotes) would result in the string “Z” to represent GMT if desired.
