CDatetime leap year problem

[indupriya9]

Hi there

I have a formula field that has the following formula.

Date(year(CDateTime ({CDR.dateTimeConnect}/86400)) + 70,
month(CDateTime (({CDR.dateTimeConnect} + 46800)/86400)),
day(CDateTime (({CDR.dateTimeConnect} + 129600)/86400))
)
This works well all of last year. But this year after the 28th of February it stopped working and gives an error message as follows:

A day must be between 1 and the number of days in a month.

Can somebody let me know what I should be doing

Thanks
ip

 

[Durango122]

hi
check with bo for leap yrar

http://support.businessobjects.com/...x_ver=&index_lang=&indexq2=&indexq3=&indexq4=

good luck

Durango122
Remember to used all fingers when waving to policemen