Perspective table component adds an offset to date column, why?

Ignition
1

I am confused.

Gateway System Time is: 17 hour (UTC)

Project timezone is:

image
image563×306 20.6 KB

The Dataset value is (UTC):

image
image174×201 3.89 KB

But Table display is offset (UTC + 5)?

image
image149×303 3.73 KB

Why Table display offset time??

2

I don't know, but since you're not getting any answers here can you post the JSON for the date column properties or even a screengrab of the configuration?

3

Double check that the session timezone ID hasn't been overwritten.

4

Thanks for keeping tab.

I have this on my project script:

The dataset tag have two columns (date and log):

def create_tag():
	## create dsErrorLog tag
	parentPath = "[default]Settings"
	tagName = "dsErrorLog"
	tagPath = parentPath + "/" + tagName
	if not system.tag.exists(tagPath):
		#create tag
		tag={}
		tag['name'] 		= tagName
		tag['tagType'] 		= 'AtomicTag'
		tag['valueSource'] 	= 'memory'
		tag['dataType']		= 'DataSet'
		tag['value']		= system.dataset.toDataSet(["date","log"], [])
		system.tag.configure(parentPath, [tag], collisionPolicy="o")

def error_logger(newMsg):
	tagPath="[default]Settings/dsErrorLog"
	ds = system.tag.readBlocking(tagPath)[0].value
	newDs = system.dataset.addRow(ds, [system.date.now(), newMsg])
	system.tag.writeBlocking([tagPath], [newDs])
	return None

The gateway timezone is UTC.

Seems that, the perspective table component is wrongly assumed the timezone of the date column on the dataset tag.

One work-around I found, cast to string str(system.date.now()) so that it will specify timezone as well.