month name module

  • Thread starter Thread starter Catherine Cook
  • Start date Start date
C

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
 
Catherine Cook said:
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
Click to expand...

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

Format([DateValue], "mmmm")
 
Catherine said:
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?
Click to expand...


Sure you can;

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