Recently there was a requirement for me to get the first day of the current year. After banging my head here and there found following solution online and it works like charm. <3
DECLARE @START_DATE_YEAR DATETIME SELECT @START_DATE_YEAR = DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)
Subscribe to our mailing list
Subscribe to our mailing list and receive a free udpates
Leave a Reply