wrong display of date in the BIP report

Question

Summary

Content

I need to display date in my report.I have given format as DD/MM/YYYY.

'31-12-9999' is displayed as '31-12-1999'.Kindly help me to resolve this.

Will i face some other issue in displaying date if i give this format.

C E · Answer

Hi All,

When i used  ''MM/DD/RRRR" date was properly displayed as '31/12/9999'. But still in export copies am getting Special character ######.

And some dates are printed as 02/04/RRRR.

Please help me.

Venkat Thota - BIP · Answer

post what exactly your backend data for field the look like and what formula you applied on field? Thanks

C E · Answer

Hi,

Thank you for your reply.

I used ''MM/DD/RRRR". Then it was displayed properly as '31/12/9999'.