Search
-
Re: SQL Query by date
-
Re: SQL Query by date
This is definitely closer. So I run this in SQL with success: SELECT TOP 25 CAST(MONTH(Created) AS varchar(2)) + CAST(DAY(Created) AS varchar(2)) + CAST(YEAR(Created) AS varchar(4)) FROM [CiresonDB].[dbo].[WorkItem] But from the SQL Chart Widget, this fails: SELECT TOP 25 CAST(MONTH(wi.Created) AS varchar(2)) +… -
Re: SQL Query by date