Hi
A small puzzle I am hoping someone can help with, a field in my query needs to just show the month name of the date value so I have
Month: MonthName([Field Here]), False] which I believe should give me a non abbreviated month name in my field. When I view my query it returns #Func!
If I use Month: Month([Field Here]) it returns the correct value, but I would like it to show the month name rather then the number.
Any one can offer some guidance?
Thanks
A small puzzle I am hoping someone can help with, a field in my query needs to just show the month name of the date value so I have
Month: MonthName([Field Here]), False] which I believe should give me a non abbreviated month name in my field. When I view my query it returns #Func!
If I use Month: Month([Field Here]) it returns the correct value, but I would like it to show the month name rather then the number.
Any one can offer some guidance?
Thanks