formatting month names in BO

[eja2000]

as at now, all the month names are in Caps....
how can i format them to be initial Caps then the rest small letters?
thx

 

[blom0344]

Combine the BO functions Lower, Upper, Substr and Length to get this done:

First establish the length of the string.

Concatenate the first position of the string with the rest, like:

=Upper(Substr(<string>,1,1))&
Lower(Substr(<string>,2,(Length(<string>)-1)))

T. Blom
Information analyst
tbl@shimano-eu.com