"Monthname" Function

[diversoln]

I developed a little db using Access - XP and brought it to the job site where they have Access 2000. The function Monthname does not seem to be supported by Access 2000.

Is that true?

How can I find out what "built-in" function incompatiabilities I may have in the future?

I suppose I can hard code a function where 1 = January etc to get around this problem....

Anyone experience this kind of incompatibility? What did you do?

 

[The_Doc_Man]

You actually want Format$ where the arguments are a custom field mask and the date, not necessarily in that order.

I think it is like, Format$( "mmmm", [datefield] )

But look up Format, customized date/time fields

That should clear it up for you.