Hi all, I just want to display the current date on a modern dashboard.
Not sure which is the best widget to use?? a table will do and I don't know what SWSQL will give me what i want. Any help would be appreciated.
-- I'm not sure if you actually *need* the FROM lineSELECT GETDATE() AS [Current Date]FROM Orion.Engines
The tricky bit here is making sure (hoping) the browser automatically shows the proper date (according to your client's time zone settings).
Also, since you'll be displaying it from a table, you'll probably want to put in a automatic refresh on the table, so the time is at least slightly current.
You could also do it in the stupidest way possible...as a bunch of KPI blocks.
Why does this make my page feel ominious, like I'm counting down to something.
Because reasons.
i use this SELECT TOP 1 Concat ( '' , (getdate())) as [Time] FROM Orion.Nodes