Watson Supply Chain Ideas

Submit new product ideas for Watson Supply Chain solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed. Order Management, Store Engagement, Watson Order Optimizer, Inventory Visibility, CPQ and Call Center are now part of Watson Supply Chain

Connect with IBM experts and your peers on the Supply Chain Collaboration Community and the Order Management Interest Group

Submit ideas for other Watson Customer Engagement Products:

Watson Marketing
Watson Campaign Automation
Watson Commerce

add finctions to support Timezone in ITX

ITX lacks in Timezone based functions. we require functions to support
1) get current time in timezone
2) get current time in UTC
3) covert input timestamp to timezone.
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jan 9 2018
  • Needs More Information
How will this idea be used?
What is your industry?
What is the idea priority? High
DeveloperWorks ID DW_ID110452
RTC ID RTC_ID551028
Link to original RFE http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=110452
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    27 Feb 20:18

    Definitely an vote from me and my team on this capability!

     

    We adapted/developed a UTC timezone function that is pretty good but not perfect.  It only works in EST/EDT (although it can be adapted).  That's the key problem we were trying to solve - we need a fixed time reference that doesn't change with Daylight Savings Time.

     

    The function is:

     

    = IF( FROMDATETIME(CURRENTDATETIME(), "{ZZZ}") = "EST",

                      FROMDATETIME( ADDHOURS ( CURRENTDATETIME(), 5), "{CCYYMMDDHH24MMSS}" ),

          FROMDATETIME( ADDHOURS ( CURRENTDATETIME(), 4), "{CCYYMMDDHH24MMSS}" )

        )

     

    We had discussions on this on the IBM forum many years ago:

    https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014733440&ps=25

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    05 Aug 09:49

    We should also be able to specify the TZ that the map runs under as a parameter when calling the map.