Troubleshooting
Problem
Running a report which contains a date query calculation, the following error is generated:
The argument at position 2 of the function '_days_between' is invalid in data item 'DataItemName' of query 'QueryName', expected one of the following types: 'date, dateTime'
Cause
The second argument of this function in the calculation is a string datatype.
Resolving The Problem
Ensure the datatype for both arguments is one of the following types: date or dateTime
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m500000008d78AAA","label":"Reporting"}],"ARM Case Number":"TS012894930","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
15 May 2023
UID
ibm16991647