Deduct year from Oracle field

[Former Member]

Hi,

I have a field in an Oracle database that stores dates, e.g. 31.12.2010, field type = DATE.; I now would like to deduct one year from this field in Crystal Reports 2008... Unfortunatley I don't find a solution... some hints?

Thanks!

[Former Member · Accepted solution]

dateadd("yyyy", -1, yourdatefield)

Ian