date display

[jrthor2]

I have a database that stores the dates as a "Short Date" (12/9/2003). When I display the date to a user, I want it to show the actual month name (Ex. December, January, etc). How can I do this?

[MichaelM]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctFormatDateTime.asp

[jrthor2]

that works, but it is showing the weekday first. I don't want to show the weekday, I just want to show for example December 9, 2003.

[MichaelM]

dtDate = FormatDateTime(dtDate, vbLongDate)
Response.Write "<HR>" & Mid(dtDate, Instr(1, dtDate,",")+2, Len(dtDate))

[jrthor2]

thanks, worked like a charm