Need 2 Formulas in One Field 2

[hebuna]

I'm a newbie using Crystal Reports 11 & SQL Server.

I am trying to change both the date and year in a field. I know how to do one or the other:

DateAdd ("YYYY",+2,{SCContracts.ExpDate}) or
DateAdd ("D",-1,{SCContracts.ExpDate})

but I don't know how to make it do both. Any suggestions? Thanks!

 

[lbass]

Try:

dateserial(year({SCContracts.ExpDate})+2, month({SCContracts.ExpDate}), day({SCContracts.ExpDate})-1)

-LB

 

[synapsevampire]

Try:

Dateserial(year({SCContracts.ExpDate})+2,month({SCContracts.ExpDate}), day({SCContracts.ExpDate})-1)

or you can gang the dateadds:

DateAdd ("D",-1,DateAdd("YYYY",+2,{SCContracts.ExpDate}))

-k

 

[hebuna]

Thank you so much! That was perfect!