Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue to derive the time zone short code for given time zone.

Issue to derive the timezone short code for given timezone.

We are facing an issue in one of the Production Scheduling Report from Supplu chain Planning to Convert the Date/Time as per the timezone given in 'Production Scheduling Organization Table'.
We have a below function available in ERP to convert the time/Date to new timezone:

new_time(mce.start_date, <From Timezone Short code>, <To Timezone Short code>)
Ex. new_time(mce.start_date, 'GMT', 'MDT')

The issue is, from where to get this short code 'MDT' based on the timezone name that we have(Timezone name: America/Denver).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!