date conversion

J

John

How do you convert a month number into the month word? I
have a report that prompts the user for the month number
and then returns the data for that month. I want to put a
label at the top of the report that shows what month that
data is for. Example:

User enters: 8
Report shows data for August
When the user enters: 8
I want the report to return the word "August" in a label
field on the report.

TIA,

John
 
R

Ron Dyson

-----Original Message-----
How do you convert a month number into the month word? I
have a report that prompts the user for the month number
and then returns the data for that month. I want to put a
label at the top of the report that shows what month that
data is for. Example:

User enters: 8
Report shows data for August
When the user enters: 8
I want the report to return the word "August" in a label
field on the report.

TIA,

John
.
 
Top