MS Excel / VBA help thread

You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.

•

might help:

SET dateformat dmy
DECLARE @StartDate as datetime
DECLARE @EndDate as datetime
SET @StartDate = '01/01/2016'
SET @EndDate = DATEADD(month, DATEDIFF(month, 0, getdate()), 0)

your_query

WHERE your_date>=@StartDate AND your_date <@EndDate

•

Chalfie in reply to @ObiWomKenobi

Thanks.
In the end I used....
WHERE [Date entered]<=DateSerial(Year(Date()), Month(Date()) + 0, 0)

MS Excel / VBA help thread

About

LFGSS