month name module

[Catherine Cook]

I had to convert a dbase from 2002 to 2000 and 2000 does
not like the MonthName( ) command... can I build a module
into the dbase to help it?
thanks

 

[Rick Brandt]

I had to convert a dbase from 2002 to 2000 and 2000 does
not like the MonthName( ) command... can I build a module
into the dbase to help it?
thanks

What argument does MonthName accept? A Date? If so, just use...

Format([DateValue], "mmmm")

 

[Marshall Barton]

I had to convert a dbase from 2002 to 2000 and 2000 does
not like the MonthName( ) command... can I build a module
into the dbase to help it?

Sure you can;

MonthName = Format(DateSerial(2003, monthnum, 1), "mmmm")