Leading 0's in formula

AustinBauer

I'm creating a formula where my posting period is between 1-9 then I want it to be given a leading 0. I have created the following formula but I am getting the error "Invalid type in operator >="

Can someone help me fix the below formula? Thank you

IF [Posting Period]>=1 AND [Posting Period]<=9
THEN "0"+[Posting Period]
ELSE [Posting Period]
ENDIF

scottj

The Invalid operator is due to trying to find a numeric calculation on a String.  You can use the ToNumber() function to help with this.

IF tonumber([Posting Period])>=1 AND tonumber([Posting Period])<=9
THEN "0"+[Posting Period]
ELSE [Posting Period]
ENDIF

See attached.

LeadingZero.yxmd