I'm rewriting some of my clients GV reports to enable compatibility with AR 9.0.
I ran into the following issue when displaying the AR field "Expiry Date 1" from the Credit card section of AR.
The value keyed into AR would be eg. 0510 and would display as 05/10 in the filed.
When this value is shown on a GV report it displays as 31-May-10 I need this value to display in GV as 0510
I've used a calculated column in the past to translate this info but the formula is not working on the new AR version of new GV version. The Calculated column field is: DATESTRING({Expiry Date 1} ," %m%y" ) This is not working and is causing the GV App to crash. Any thoughts.

Thanks
_________________________
Kevin R. Belyea, CMA
Spartan Systems Limited
Rothesay, N.B.
506-650-0888