Data Table with Date

Questions
1

Hi everyone,
I’m running into a strange behavior with the Data Table node.

In my table, I have a row that contains a date field.
When I save the date, the value is correct and includes the time zone. However, when I retrieve the row using the Data Table node with the Get Row(s) operation, the returned date seems to lose the time zone and is interpreted as UTC, so it ends up being shifted.

I’m attaching some screenshots for clarity.

Has anyone else encountered this issue?
Is there a way to make the node preserve the original time zone, or do I need to handle it manually afterward?

Thanks!

data table

data table - res
data table - res1395×404 40.2 KB

2

Probably mismatch in workflow timezone. Go to workflow settings and make sure it matches the input timezone.

If you are still encountering the issue, set the data table column type as String instead. Use Date & Time node to format it into what you prefer afterwards.

3

You can manipulate the data / time according to your timezone using code node with javascript.