we created the flexibility to allow the uses to enter in
MM/YYYY (08/2008) or
MM/YY (08/08) or
M/YYYY or
M/Y or
M/YY or
MM/Y.
The date format is accepted in the query correctly. When these reports are printed out, it was also displayed in the header as MM/YYYY irrespective of any of the above date format entered in the parameter screen.
But due to some maintenance to the Business Objects servers last week (moved to the new server and reports are imported) by the network team the DISPLAY is failing to show up as MM/YYYY format. And those with MM/YYYY are displaying correctly as 08/2008, but when printing out the non four digit year combination, it prints out as 0008 (instead of 2008). In addition, if you enter in a thru date range (08/2008 09/09) it will print out 08/2008 through 09/0009. This is ONLY an issue with the header display, data retrieval into the report is perfect.
There was also OpenDocument problems, and we are able to fix them.
Here is the formula I am using, which was working fine before move,
="Beginning Month/Year: "+FormatDate(ToDate(UserResponse("Choose or Enter Beginning Month/Year: “);“MM/yyyy”); “MM/yyyy”)+” Ending Month/Year: "+FormatDate(ToDate(UserResponse("Choose or Enter Ending Month/Year: ");“MM/yyyy”); “MM/yyyy”)
Searching around found that fixing the PRM file might fix this problem, I still need to look into it.
Let me know your thoughts.
Thanks
Gary
bogary (BOB member since 2007-03-09)