format date function error

[binboy77]

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.

FormatDate(<datedimension>,"mm/dd/yyyy")

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

 

[dgillz]

What error are you getting? Also why is the datedimension surrounded by greater than/less than symbols? Is this a database field?

Are you using Business Objects or Crystal Reports?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[vidru]

You might have better luck in the Business Objects solutions forum: forum393

-dave

 

[binboy77]

thanks all,
I am using business objects.
I suppose this is not the right forum that i have placed my question. i would be putting this Q in the BO forum.


Bin