Multi-tenant dates and times

We are working on a migration from v10 on premise to the MT CSF/GHR cloud. One issue i'm running into is with javascript dates. Because it is on the MT server, all the date objects get initialized in UTC. Does anyone know how to get dates to initialize in either the desired timezone or adjust it after creation? We're central time so we switch between GMT-5 and GMT-6 depending on daylight savings time.

We did find the timestamp.getTimeZoneCurrentTimeStamp(timezone) built-in function in IPA but that creates a date string rather than a date and when I try to pass it back into a new Date() function, it tells me it is an invalid date. I'd like to get it as a date object so it can be manipulated.

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

unknown

Hi Robert,

You can make use of available JS libraries as to modify the date and timestamp according to your requirement and the timezone.

https://momentjs.com/

This is one such approach and there are many more. Hope, this helps.

Regards,

Naresh.

unknown

We created a configuration variable timezoneOffsetPST and it's set to either 7 or 8 depending on time of the year. Of course you have to manually change this.

in the process flow start node add these variables

timezoneOffset = _configuration.PeaceHealth.timezoneOffsetPST
tdate (type: date) = new Date(today().getTime() - (timezoneOffset * 60 *60 * 1000))
CCYYMMDD (type: String) = (tdate.getFullYear() * 10000) + ((tdate.getMonth() + 1) * 100) + tdate.getDate()
HHMMSS (type: string) = ((tdate.getHours() * 10000) + (tdate.getMinutes() * 100) + tdate.getSeconds()+1000000).toString().substr(1,6)

Hope this helps.

Pam

andy

Are you just manually adjusting the offset config variable when daylight savings ends / begins? If so, you could also derive that based on whether current date is in between or equal to the second Sunday in March and first Sunday in November in the current year. I actually just had to fix this in one of our App Studio BI Reports built by ICS.

robert-canham

That helps, thanks for sending that over. I also came up with a function that uses the IPA built-in timestamp functions. the unfortunate part is that it returns a string, but I was able to parse it out into a date.

tdate (type: date) = currentDateTime("US/Central");

unknown

That is a very useful function, we would not have to change our configuration variable between 7 and 8, twice a year. Unfortunately we have 190 process flow that we'd have to change.....

Copyright © 2025 Infor. All rights reserved.