Search
-
Re: Is it possible to use GETDATE in SQL Queries with the Dashboard API
-
Is it possible to use GETDATE in SQL Queries with the Dashboard API
Hi, we need to filter our Query with a DateTime Timestamp from the actual date. We want to get alle Workitems which are last changed in the last 1 day. Our Code SELECT DisplayName, LastModified FROM [CiresonServiceManagement].[dbo].[WorkItem] where LastModified >= (DATEADD(day, -1, GETDATE()) in Sql we get the right…