I am trying to write a function to look at a date field that has a format of:1/21/2010 and change the numerical month to an abbreviated textual month such as: Jan.
"When I run the query, it gives me an eror of " wrong number of arguments used with function in query expression 'datetomonth([obdate])'
Here is the function:
Public Function datetomonth()
MonthName(1, True)
monthname(2, True)
monthname(3, True)
monthname(4, True)
monthname(5, True)
monthname(6, True)
monthname(7, True)
monthname(8, True)
monthname(9, True)
monthname(10, True)
monthname(11, True)
monthname(12, True)
End Function
They are all in red too..which makes me think I did something wrong.