IBM Support

Date format pattern YYYY appears different in Excel compared to HTML and PDF.

Troubleshooting


Problem

For Date 2020-12-31, Format of YYYY (based on week of year) will return 2021 in HTML and PDF.

When exported as Excel it display YYYY (based on week of year) 2020.

Document Location

Worldwide


[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl4NAAS","label":"Modeling-\u003EFramework Manager"},{"code":"a8m50000000Cl5QAAS","label":"Reporting-\u003EOutput formats and rendering"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Cognos Analytics

Component:
Modeling->Framework Manager, Reporting->Output formats and rendering

Software version:
All Version(s)

Document number:
6402511

Modified date:
06 May 2025

UID

ibm16402511

Manage My Notification Subscriptions