Convert UTC to local dates/times in IPA?

The dates in the IPA Landmark database are stored as UTC. I want to display these in the local date/time for our users in the notifications they receive from IPA flows. In the Designer, what is the Assign node code to convert a datetime field from the Landmark database to local date/time? For example, in PfiMetrics table, the datetime field is 2016-10-24 17:14:47.460 (which is UTC). I want to display this to the users as 12:14:47 LOCAL time. Thank you

Find more posts tagged with

Infor Lawson Technology Group - Discussion

Comments

unknown

Infor provides multiple function in the IPA Assign node for converting dates. If none of those works you and create your own custom JavaScript function using pflow.js as described in the IPA Designer Guide manual.

plancor

Thank you for the reply. Converting from UTC to local datetime is not a built in Infor function - but that would be an appreciated enhancement

In IPD, you can write javascript directly in the Assign node. Could anyone provide the javascript code that converts UTC datetime to local datetime? Thank you

unknown

Hi plancor - the challenge is...what do you mean by "local time". IPA will likely determine "local" by the way the Landmark server is set up, which is very likely not what you are looking for. If that IS what you're looking for, I suppose you could use the Javascript getTimezoneOffset() method to get the offset (minutes) and then use other javascript code to add (or subtract) the minutes from the base date.

Sorry this isn't really the full answer you're looking for, but Google is your friend for something like this - you'll probably get better answers just searching for "javascript add minutes to date" or something similar.

Good Luck!

Kelly

unknown

To add to what Jim said - if you decide to add a custom function to IPA, be sure to create a new file named "pflow_user.js" rather than modifying the delivered "pflow.js". You can clone the "pflow.js" to get the layout, but if you create a "pflow_user.js" file and drop a copy on each server and in your designer install folder, then future IPA upgrades won't wipe our your custom functions. The custom functions will appear in the function list just as the delivered functions are.

Also, you can "extend" the functions in "pflow.js" by adding the extensions to "pflow_user.js" without mucking with the delivered code.

Kelly

unknown

Try using Moment.js libraries by which you can convert to whatever time you want based on the user's timezone. Try adding the library script in the Javascript of the Assign node and manipulating the variables based on the output format, you require.

Thanks,

Naresh.

Dr. Awesome

You might look into using Config Console and User Derived Fields to handle this. Landmark has built in ability to give you your timestamps in your "corporate" timezone vs server time (typically UTC).

Check the dev guide for setting corporate time zone and using "corporate" in your LPL.

Also, LPL can handle a +/- hours offset calc if needed. However, IPA executes on the server so there isn't really a notion of an end-user's timezone (unless you track that somehow). Do you have and +/- offset per user somewhere? For this approach you will likely need to share the date/time AND the timezone info to be super clear what they are looking at.

I'd guess that using a corporate timezone and for those users outside of that timezone (if any) they typically know their + or - from corporate.

Copyright © 2025 Infor. All rights reserved.