Hello
I have an object called reporting period which brings in MAY 2004. I need to convert this to show it as 05/04. I tried Todate(,“mm/yy”) and I get an #Error in the cell.
Can someone please suggest how I can get this to working?
The string format for the ToDate function is the INPUT format. It tells the ToDate function how to interpret your character string. You need something like this to convert your string to a date:
ToDate(<Reporting Period> ,"Mmm yyyy")
At this point you can simply format the cell to display mm/yy. The other alternative is to wrap the above in another function:
When you use the Business Objects Reporter function ToDate the parameter expected is the existing format of the Date string (and not the target formattting), for example: