Data Management: Cognos Data Manager (v8.3): ToDate Error

The ToDate function has an annoying feature whereby it will translate a DATE STRING that is NOT in the format provided AND it will get it WRONG!

e.g. it will translate ’09-09-09′ using $!MyDate := ToDate($inputString, ‘dd-mm-yyyy’) to 9-September-0009 instead of the expect ‘null’ which would normally happen for non-matching date strings.

The year 0009 (or the other possible years 0000-0099) can be detected using something like:
If ( ToInteger(!ToChar($!MyDate, ‘YYYY’))

Related Articles

QMetrix is named 2024 APJ Workday Adaptive Planning Partner of the Year

QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner  of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage

A Guide to Selecting the Right Financial Planning and Analysis Solution

From Features to Functionality and Cost: A Comprehensive Guide to Selecting the Right Financial Planning and Analysis Solution You might have heard of Anaplan, Board, Workday Adaptive Planning, TM1, IBM Planning Analytics, Oracle and Planful. These are tools that aid Financial Planning and Analysis (FP&A). They have the potential to elevate your financial planning, budgeting,

Stay in touch

Get the latest insights from QMetrix straight in you inbox.

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information

Skip to content