After Form personalization the year in END_DATE is displayed as 0015 instead od 2015

Hi,

Can anyone please help with the below  issue:

I have created an SIT and personalized the for SIT, to default

END_DATE as start_date plus 1 year. I am using the below query under the value

filed in personalization:

=add_months(:ANALYSES.DATE_FROM,12)

It is not

throwing any error , but the end_date is defaulted to 07.24.0015 instead od

07.24.2015 . When I try by using to_char as below:

to_char(add_months(to_date(:ANALYSES.DATE_FROM,

'DD-MON-RRRR'),12),'MM.DD.RRRR')

The date is displaying properly, but the

cursor is not moving and getting error like 'Not a valid month'.