Search
-
Dashboard - 'First of the Week' Relative Date Searches
The dashboards have been a great addition to the Cireson tool set. One issue that I keep running into is building a weekly report query without it being a continuous count. As it stands now there are three operators that allow first of the month,quarter & year but week is missing. Change to a "days ago" operator and now… -
Re: Dashboard - 'First of the Week' Relative Date Searches
I did something like this... (Today)AND DATEDIFF(dd, ResolvedDate, GETDATE()) = 0 (Yesterday)AND DATEDIFF(dd, ResolvedDate, GETDATE()) = 1 (This Week) AND ResolvedDate >= DATEADD(wk, DATEDIFF(wk, 0, GETDATE()), 0) (Last Week) AND (ResolvedDate >= DATEADD(wk, DATEDIFF(wk, 0, GETDATE()) - 1, 0) --first day of last weekAND…