Easy date formatting question

[J. Muenchbourg]

I have a variable that represents a standard mm/dd/yyyy date , but i
want to change it to just October 6

''''

datepart("m","d" , mydatevariable)

'''''

....doesnt work.

Muench

 

[dlbjr]

Function MyDateFormat(dtm1)
If IsDate(dtm1) Then
MyDateFormat = MonthName(DatePart("m",dtm1)) & " " & Day(dtm1)
End If
End Function