ryanhamilton
commented
1 year ago user-ea
I query an analytic that returns a table – the first row in the table is called Date and is of type D. This is now represented correctly in the table (it used to auto convert to date-time – it no longer does that – hurray).
However, when I open up the debug – it shows the value of this column as type Z.
i.e. the analytic returns a table with column date of type D with value 2023-02-21
the grid shows 2023-02-21 on the graph
the Date variable in debug is 2023-02-20T13:00:00.000Z (adjusted to Sydney time).
So when I want to use this as a date (not a date-time), I have to add 11 hours onto it before I turn it back into type D or I’m querying the wrong information. I think the Debug variable should be of the same type as the underlying data.
Clicking on a table row with a date column Sets a date time If a user is in a timezone +2, that date can be different as it moves. e.g. Query a table with row for today, set timezone to huge difference. Click on the row The data sent will be different than displayed due to timezone shift.