format ("07", "MMM")

[sbcaco]

hello,

I am trying to show the month, i.e., "Jul" in a report based on a field with
a value of "07"

using =format ("07", "MMM") in the text box, it shows Jan, not July.

what is wrong? thanks!

 

[Ken Snell \(MVP\)]

Try this:
=MonthName(7)

 

[sbcaco]

Thanks, that was too easy.

I added ", true" to it to get the abbreviated month.

thanks!