Hi,
I am having trouble converting the nodes last response time from UTC to my Local time in Modern dashboards,
below is the query I inserted and showed it is valid before saving, but after saving it I get an error, which seems ToLocal function doesn't work on Modern dashboards!
are there any other ways that I can apply that change? or maybe using different variable than LastSystemUpTimePollUtc?
SELECT a.Caption AS [Node Name],
a.Status AS [Status],
a.DetailsUrl AS[URL],
ToLocal(a.LastSystemUpTimePollUtc) AS [Last Up time]
FROM Orion.Nodes a
WHERE (Status = 2)
ORDER BY [Last Up time] DESC
;
also on graphical query builder I have this error when selecting a format for Date and time ,
and when choosing Compact option :
