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
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
Hi Jose, I didn't use datetext function earlier in my code.. Now I added datetext(ri!var.toDate_date, "yyyy-MM-dd") and this removed Z from the result. Actually I am calling the table in my process that generates e-mails. I think 'Z' is added from the process.
Thanks,