Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Format Bug using singleton for date?

    Posted Wed January 02, 2019 10:06 AM
    Edited by System Admin Fri January 20, 2023 04:15 PM
    VOID this question.. I found the issue, I need to use 'yy' not 'YY'.  Thanks!

    ​I've come across 2 instances where when a format is applied to a field on a report, it doesn't return the information expected.

    Example 1: 
    Query1 with one field  - maximum(date_updated)
    Query 2 has details and facts
    Report output, I use a 'singleton' to pull in the  maximum date field from Query 1 to use in a title on the report.  All runs fine, the report data is correct and the 'Maximum Date' field is correct displaying '12-31-2018'  However, when I go to the format properties of the 'Maximum Date' field on the report and apply formatting to it so it shows 'MM/dd/YY' it returns 12/31/19 ??  The only way I have found to correct this is to apply the formatting to QUERY 1 as such:

    to_char(Maximum(date_updated, 'MM/dd/YY').  Then the data returns correctly (with no formatting applied at the report field level).

    Is this a bug? 



    ------------------------------
    Jenifer Broughton
    ------------------------------
    ​​
    #CognosAnalyticswithWatson


  • 2.  RE: Format Bug using singleton for date?

    Posted Thu January 10, 2019 02:58 PM
    @Jenifer Broughton

    Thanks for posting the community!

    I'm glad it worked for you. Please continue posting your questions to the community, we're doing our best to answer questions in a timely manner.

    Thank you,​

    ------------------------------
    Sami El Cheikh
    Offering Manager
    IBM Cognos Analytics
    ------------------------------

    Original Message


Related Content