using format function

[ariel81]

i use the format function to display month, here is the code below:


Format(MthInput, "mmmm")

however, whatever MthInput value is used say 1,2,3...
the month display will always either be december or january why is this so?

i want it to be 1 -> january
2 -> feburary
:
:
12 -> december

did i use the format function correctly?

 

[Dennisk]

it is a date you are formatting not a month number

Format(#01-12-01#,"mmmm")

and not
Format (12,"mmmm")

 

[ariel81]

because i am inputing the month only and not the whole date.
how can i use the month only?

 

[RuralGuy]

Try MonthName(MthInput)

 

[ariel81]

thanks alot...

 

[RuralGuy]

Glad to help.