Changing a Date to Text

[sdimaggio]

I am trying to get a textbox which has the =now() formula to display text.
I have a formula that is trying to issue an approval number.

=[Lab ID] & -[customer Number] & -[month]

123 - 45678 - 02 <<- this is what I want

the first two parts work but when I add [month] I have a feeling the [month] is still a number and my result is ?#name. I formated a textbox called month which is formated to show &quot;02&quot;.

how do I get the textbox to be text?

thanks steve

 

[67peshawar294]

Hi,
Try putting:
=Month(now())
in your text box.
Jim

 

[67peshawar294]

OOPS,
I just noticed you want two digits.
You could add an
=&quot;0&quot; & month(now())
which would give you two if month is 9 or less but three if 10 or more.
if you need two digits try
=IIf(Month(Now())<10,&quot;0&quot; & Month(Now()),Month(Now()))
Jim

 

[hermanlaksko]

=format(Month(now()),&quot;00&quot will do the trick