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

Hi, Kevin,

It appears that %y is broken. I've reported this to R&D for you.

In the meantime, you could create a calculated column using:

DATESTRING({Expiry Date 1} , "%m %Y")

which would return 05 2010 .

Then, create another calculated column using:

strcat (
left({x} ,3),
right({x},2)
)

where {x} is the name of the first calculated column. This would return 05 10 . The space is necessary to have the column treated as text.

Would it be possible to get rid of the space between m & y?
this is a necessary step as these GV reports are exported to excel and used for Dirct debit processing with our bank.
Thanks

Hi, Kevin,

If you changed the 3 to a 2 in the left formula, the space would be gone but the leading zero in months 01-09 would be trimmed.

However, if you also concatenated a leading ' or space the number would remain as text. Probably the space would be best and the number would display in GV as 0510.

strcat (
" ",
left({x},2),
right({x},2)
)

Any timeframe on the hotfix?

Hi, Kevin,

As you know, Technical Support can't really speak to timeframes. The problem with %y has been referred to R&D.

No timeframe on this...

Your best bet is to send the data to Excel as mm yy ( 09 09 for example) for September 2009 and then add the additional formatting in Excel.

If D2 in Excel has 09 09 then =concatenate(left(D2,2),right(D2,2)) will produce 0909 as needed