Hello,

I'm wondering why I'm getting an error when entering "format" into the field name of a query. I'm trying to get the month name from a date by using the following code:

MonthName: Format([DateOrdered], "mmmm")

When I try to run the query, I get an error message:

"undefined function 'Format' in expression"

Thanks in advance for any help.

Check to make certain that all your references are properly linked and that the VBA library is indeed referenced.



Rand

Make sure it is a "Crosstab Query" & not a "Select Query". From Query toolbar, select Crosstab Query.
I believe, this might be the problem.
Good Luck either way!

Hi,

   I don't think that Format is Formating function in SQL (SQL SERVER); might be, it uses for formating data or else ... i have been using format_file etc. for formating file etc...

I have also tried now on to use

   SELECT FormatedData = Format(mmm,getdate())

   But got error that '
 Server: Msg 195, Level 15, State 10, Line 3
'Format' is not a recognized function name. '


  So, i prefered to use ...

  select convert(varchar,datepart(dd,getdate())) + '-' + convert(varchar,datepart(mm,getdate())) +'-'+ convert(varchar,datepart(yy,getdate())) As FormatedDate


   i have been using above way ... hope it will help you too...

 Stay Beautiful,

 Abdul Salam