SHIFTTIMEZONE - FROM TO - switched

Follow

Anson Chan

• January 02, 2021 07:43

Hello Team,

a recent operation in Datameer I'd like to shift a date Time Zone from Etc/UTC to Asia/Manila. where the result was wrong if I follow the syntax of "From" and "To"

However the result only comes to be correct under the circumstance where I flip the "From" and "To". please see below screenshot.

Please may I have your advice?

thanks, Anson

0

• 

  Konsta Danyliuk

  • January 02, 2021 08:28
  • Edited

  Hello Anson.
  This is the expected behavior. The FROM field means the current user's time zone and the filed TO - the time zone you want your DATE values to be displayed in. As this does seem confusing, in Datameer-10.1.4 we've changed the function arguments' names

  from

  SHIFTTIMEZONE(Date: <Date>;From Timezone: <String>;To Timezone: <String>)

  to

  SHIFTTIMEZONE(Date: <Date>;Time Zone 1:<String>;Time Zone 2:<String>)

  and adjusted the documentation accordingly - https://documentation.datameer.com/documentation/display/DAS100/SHIFTTIMEZONE.
  
  The changes affected only the filed names, but not the functionality of the SHIFTTIMEZONE itself, thereby you could use the new documentation for building the SHIFTTIMEZONE function, despite the fact that in 10.1.3 it has old argument names.

  0

  Comment actions Permalink

Please sign in to leave a comment.