Skip to Content

Purpose

Extract timezone from the result of built-in function CurrentTime().


Issue

Here below formula syntax doesn’t work:

Right(CurrentTime();10)


Error returned is the following: “The expression or sub-expression at position N in the ‘Right’ function uses an invalid data type. (IES 10037)”


Solution

Work around found consists in encapsulating the CurrentTime() function in an user-defined variable and update syntax as:

Right([MyTime];10)

where:

MyTime = CurrentTime()

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Sivanandh K

    Hi Sébastien Konaté,Sébastien Konaté

    Try the following,

    FormatDate(Currentdate();”z”)

    or

    FormatDate(Currentdate();”FULL_DATE_TIME”)

    This is will give you the Time Zone information.

    I would not suggest to extract the timezone from “Right([MyTime];10)” because for few locale’s timezone will not be displayed by default in the function. Ex – en_AU.

    (0) 

Leave a Reply