Monthname in MS Access

[magmo]

Hi

In SQL Server I can use this code..

DATENAME(mm, dbo.tblTest.Dateordered) AS MonthName

But how do I write the same thing in MS Access?


Regards

 

[PHV]

Something like this ?
Format(Dateordered, 'mmmm')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[magmo]

Great, Thanks a lot!

 

[RoyVidar]

Be careful with using "Monthname" as alias , as it is also a function - MonthName(Month([DateField])) - should return the monthname too;-)

Roy-Vidar