Hi,
I’m CR2008 and quering from SAP BW - I’m trying to convert a date string to display Jan 2009 to Jan 2010 for example and below is as far as I have got - any help please…thx
"Period : " +
mid(TOTEXT(Minimum ({?Period Range})),18,2) +
mid(TOTEXT(Minimum ({?Period Range})),14,4) +
" to " +
Totext(Maximum ({?Period Range}))
ShaneL 
(BOB member since 2009-04-02)
I figured it out to anyone that’s interested…
"Period : " +
ToText(CDate(ToNumber(mid(ToText(Minimum ({?Period Range})),14,4)),ToNumber(mid(ToText(Minimum ({?Period Range})),18,2)),01),“MMM yyyy”) +
" to " +
ToText(CDate(ToNumber(mid(ToText(Maximum ({?Period Range})),14,4)),ToNumber(mid(ToText(Maximum ({?Period Range})),18,2)),01),“MMM yyyy”)
ShaneL (BOB member since 2009-04-02)