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

What is the true ROI of a planning solution?

The true ROI of a planning solution

Budgeting, forecasting and reporting is a necessary but often expensive process. Planning solutions might look like just another cost – but what is the true opportunity cost and Return on Investment?

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