ncolumntable

Hi,

 

I am using 'ncolumntable' function to generate a table .It looks similar to below

ncolumntable(

{ "Effective Date"

},

ri!var.toDate_date

)

var is a ruleinput of type CDT.

In the UI, the column record shows the date concatenated with Z.

Expected result: 2018-08-12

Actual Result:: 2018-08-12Z

Any help on why the "Z' is added to the result and how to achieve the expected result will be appreciable.

 

Thanks ,

Rohini

  Discussion posts and replies are publicly visible

Parents
  • Hello Rohini

    Normally a Z means zero offset or UTC+0.

    And when using the function datetext  when adding a Z means you want the time offset displayed

    datetext(today(),"yyyy/MM/ddZ")

    Can you share the string you are using as format ?

    Just in case it is something like the following, Jeb the problem is the single quotes around the Z

    datetext(today(),"yyyy/MM/dd’Z’")

    Some thoughts, Is this happening inside a process? Try to set the process timezone. Or the user timezone do you have one set? And the default timezone in Appian?

    Hope this helps

    Jose

Reply
  • Hello Rohini

    Normally a Z means zero offset or UTC+0.

    And when using the function datetext  when adding a Z means you want the time offset displayed

    datetext(today(),"yyyy/MM/ddZ")

    Can you share the string you are using as format ?

    Just in case it is something like the following, Jeb the problem is the single quotes around the Z

    datetext(today(),"yyyy/MM/dd’Z’")

    Some thoughts, Is this happening inside a process? Try to set the process timezone. Or the user timezone do you have one set? And the default timezone in Appian?

    Hope this helps

    Jose

Children