Need syntax for 1 year prior the given date

[teddysnow12]

Hi,

I need a syntax which gives 1 year prior to a given year .

My field is rptg_yyyymm.
the datatype is string.

example : The values are like this,

'2008-01'
'2008-02'

I should convert this into date format and also need syntax for 1year prior this date like,

if the given year is 2008-01,
the prior year is 2007-01



Thanks!

 

[Alan0568]

convert(varchar(4),convert(int,substring(rptg_yyyymm,1,4))-1) + '-' + SUBSTRING(rptg_yyyymm,6,2)

 

[teddysnow12]

thank you for you response.
but it is throwing an error saying ' Missing expresssion' and pointing at varchar

 

[Alan0568]

please post the sql (context) in which you are using it.

 

[teddysnow12]

It is working.
Thanks a lot.