Date to Text

[Leather Knight]

How do I have the "date" field convert to a text output? So if the date is March 2, 2006, the result is "2006-March"?

I tried this but the March shows up as "2"

GetAsText (Year(Trip Date) ) & GetAsText ( Month(Trip Date))

Thanks.

[Lee Smith]

Year(YourDateField) & "-" & MonthName(YourDateField)

Lee

[Leather Knight]

Thanks Lee. That was it.