Date formating in Asp - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

que · 08-03-2005, 04:51 PM

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 · 08-04-2005, 08:30 PM

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.