using DATEPART function in a SQL where statement 1

[jerrylj]

I am using the following in a where statement for a sub-select: glpastyr.calmonth = DATEPART(month,getdate())-3

this will work fine if the current date is greater than march 31 of any given year. If it is less than 3/31/xxxx then an error is returned because the month becomes a negative number.

Do any of you know of a way around this?

 

[bdreed35]

Can you use the DateAdd function?

In SQL Server it would be:

WHERE glpastyr.calmonth = Month(DateAdd(month,-3,getdate())


~Brian

 

[jerrylj]

Thanks it looks like that will work. One of the problems with being self tought is not knowing all of the functions.