Format from 2 to 02

[Guest]

My expression is

Format([Field8]),"00")

This should turn period 1 into 01, and period 2 into 02, so that 02 will
come before period 10,11 and 12 when it is sorted in the OLAP cube

However I am getting ;

The expression you entered contains invalid syntax, or you need to enclose
your text data in quotes

Any one have any idea on this one : the field is formatted as text in the
design mode, of course I have tried to format it as a number but this does
not solve it.

Thanks

 

[Douglas J. Steele]

You've got an extra closing parenthesis after the closing square bracket. It
should be:

Format([Field8],"00")