Igwiz,
I too have encountered the EXACT same problem. I have yet to find a solution. It is only when you use the workbooks.open or workbooks.opentext commands that the date is converted to american date. Clicking on file > open from the menu does not cause the error.
It is VERY frustrating...
Calling all CMS Custom Report Experts.
I am trying to create a Historical Report that can group by Agent Group & Split/Skill that can be run over a single or multi-day range in CMS r11.
I have created the report with the following inputs:
Agent Group, Split/Skill & Date. (Split/Skill & date...
Cyan8812,
We use 8.5 here and yes toWords(x) is still a function.
You can also use ToWords(x, #places) where #places is a whole number indicating the number of decimal places to be converted. (This argument is optional.)
Hope this helps tbiggs!! :-)
Dave
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.