hi i was wondering if anyone could help me explain what the -1 does in this code
WHEN As_of_Date > DATEADD(yy,DATEDIFF(yy,0,[Date_To])-1,''19000701'')
AND As_of_Date <= DATEADD(yy,DATEDIFF(yy,0,[Date_To])-1,''19000930'')
ELSE 0.00 END
and how would it affect date_to dates when one is 20151231 and the other is 20150630.
when i take the 1 away it works for 20151231 but not20150630.