Simple qu hopefully.
I am trying to run a query (scheduled) to group the date field by day (ignoring time). How can Id do this so the report can be run every day?
select top 1000 CONVERT (date, SYSDATETIME()) TodaysDate,
count(fieldname) as validateddate FROM databasename
WHERE Convert(DATE, fieldname) = '2018-08-01'
I have this for one day.. but I don't want to have to manually change the date