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.
_________________________
Regards,
Softrak Tech Support