How to get 1 year prior in SQL

[teddysnow12]

Hi,

I need syntax in SQL to get 1 year prior for a given year.


Thanks!

 

[arodri]

Have you tried: dateadd (year, -1, yourdate)

 

[teddysnow12]

it is saying that dateadd is an invalid identifier.
The field related to this is rptg_yyyymm.
and teh value is like this '2008-10' (yyyy-mm)
the datatype is string.

do you think first i need to convert it into date format and then calculate the prior year?

 

[lbass]

teddysnow12,

Are you in the correct forum? I noticed your earlier thread was not specifically a Crystal Reports question. If you are looking for SQL solutions, there are forums specifically devoted to this.

-LB

 

[arodri]

Yes - I believe you need to do that first:
Select convert(datetime, dateadd (year, -1, @yourdate), 101)

 

[teddysnow12]

I will post the questions in SQL threads.

sorry for inconvinience.