creating a new field to be used in a filter 1

[MzKitty]

I need to create a new date field based on an employee's hire date 99/99/9999. I need to insert the year from today into the year for the hire date. If someone's hire date is 12/07/1987 then my new date field would be 12/07/2005. How is this done in Cognos?

Cathy

 

[DrSimon]

Try this calculation:

number-to-date(Year(now()) * 10000 + month(Hiredate)* 100 + day(HireDate))

Simon Rouse