Exception, timer, and Timezone

sergeiz over 6 years ago

Hello All!

What is the right way to set up exception for midnight in different timezone?

I have a subprocess with GMT timezone, but it overridden by the calling process to EST timezone.

The exception time set to CDT field that has Date type. Timer set with "Skip this node at the date and time specified by this expression:" with this value.

Unfortunately, the exception happens at GMT midnight, to EST. I tried to replace value with local(pv.expectedDate), but it moves the moment backward.

How I can have time trigger at EST midnight or how I can have a correct value for this expression?

Discussion posts and replies are publicly visible

0 Harsha over 6 years ago

I am little confused as in you want the exception as per GMT or EST, though can you try local(pv!expecetdDate,"EST") by suggesting the timezone as well? Hope it helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Harsha over 6 years ago

Also I want to mention as the local() always returns date and time so it would be better to have the cdt field as date and time instead of just date.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sergeiz over 6 years ago in reply to Harsha

I want exception in EST, but it is triggered with GMT. with local(pv!expectedDate, "EST") it is triggered 5 hours earlier, not later.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sergeiz over 6 years ago in reply to Harsha

Appian has Date type, and in this case we need to catch a midnight for this date.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Amit Mishra over 6 years ago

The local() and gmt() functions are used to arithmetically modify the stored GMT timestamp in a particular direction, so when used, it will be a number of hours off of the value that would otherwise have been used. These functions do not store the timezone offset with the returned value.
If your requirement is user based use, override user's selected timezone from time zone setting. Thank you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel