I'm trying to understand someone else's syntax: -
These are the parameters: -
DECLARE @TodayStart AS DATETIME, @TodayEnd AS DATETIME
SET @TodayStart = DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)
SET @TodayEnd = DATEADD(dd, 1, @TodayStart)
This is the 'where' part of the query: -
WHERE [ReceiptDate] >= '''+@TodayStart+'''
AND [ReceiptDate] < '''+@TodayEnd+'''
Can anyone tell me what date range will be returned by this query?