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.
however, this is giving me #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
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.
Code:
FormatDate(<datedimension>,"mm/dd/yyyy")
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
Bin