Skip to Content
0
Former Member
Oct 30, 2013 at 11:56 AM

Conversion of Date/Period Format

22 Views

Dear Crystal Experts,

could you please help me to solve the puzzle?

I get from DB period as YYYYMM. And I need to change it to 3 first letters of MM+YY,

like: 201301 I want to see in the report as Jan13.

Can anyone assist with formula?..

Many thanks in advance!

Cheers,

Irina