I am trying to do a SQL call that will return everything between month/year and 1 year prior. Is this possible with out figuring out how many days in each month and 1 date minus 1 year?
TSQL has a DATEDIFF function, very similar to the one in VB.net
http://msdn2.microsoft.com/en-us/library/aa258269(sql.80).aspx
||| Check out Books Online for DATEPART and DATEDIFF functions.
No comments:
Post a Comment