hi,
i am using the BO ver 6, formatdate() function to convert a date to a string. i am passing a dimension which has date value as the first parameter and "mm/dd/yyyy" as the second.
the dataprovider is VBA and the database is DB2.
however, this is giving me the #ERROR.
when i use a datefield from a universe, the above formula works fine, but with a datefield provided by the SQL in the VBA dataprovider, it gives me the above #ERROR error.
any suggestion on how to rectify this error at BO level.
ofcourse, the workaround would be to get the conversion done at database level, but if i can get this done at BO level, then it would be great.
thanks much
Bin
i am using the BO ver 6, formatdate() function to convert a date to a string. i am passing a dimension which has date value as the first parameter and "mm/dd/yyyy" as the second.
the dataprovider is VBA and the database is DB2.
Code:
FormatDate(<datedimension>,"mm/dd/yyyy")
however, this is giving me the #ERROR.
when i use a datefield from a universe, the above formula works fine, but with a datefield provided by the SQL in the VBA dataprovider, it gives me the above #ERROR error.
any suggestion on how to rectify this error at BO level.
ofcourse, the workaround would be to get the conversion done at database level, but if i can get this done at BO level, then it would be great.
thanks much
Bin