Date formating in Asp

[que]

Hello,

I'm using FormatDateTime with vbLongDate in the following line:

<%=FormatDateTime((rsBlogEntry.Fields.Item("blogDa te").Value), vbLongDate)%>

Which returns the format:
Wednesday, August 02, 2005

I was looking at the different date formats and couldn't find one that drops the day of the week and just returns: August 02, 2005

How do you format the date this way? Thanks.

[clifford]

Hummm, well to go from the first occurance of the coma/space try this:

PHP Code:

Dim newDate
newDate = FormatDateTime((rsBlogEntry.Fields.Item("blogDate").Value), vbLongDate)

newDate = Mid(newDate, InStr(newDate, ", "), Len(newDate)) 


Can't try it right now but it should work.