formatting date time

Adam H-W · September 28th, 2004, 05:43 AM

Hi there

Can anyone tell me the code for formatting the date so that it outputs like so:

September 28, 2004

At the moment it's outputting like this:

Tuesday, September 28, 2004

and I'm using (formatDateTime(myDate,1))

thanks alot

ChrisScott · September 28th, 2004, 10:30 AM

Hi Adam,

This should do what you're after

Code:

Function MyDateFormat(pDate)
    Dim months: months = Array("January", "February", "March", "April", "May", "June", _
                "July", "August", "September", "October", "November", "December")
    MyDateFormat = months(Month(pDate) - 1) & " " & Day(pDate) & ", " & Year(pDate)
End Function

HTH,

Chris

Adam H-W · September 28th, 2004, 01:46 PM

thanks Chris

mat41 · September 28th, 2004, 07:28 PM

Adam H-W

No real need for the array if you want to minimize your code, try this:

-------------cut n paste--------------------
<%= monthName(Month(Date)) & " " & DatePart("d", date) & ", " & DatePart("yyyy", date) %>
-------------finish------------------------

Wind is your friend
Matt

Adam H-W · September 29th, 2004, 03:35 AM

thanks guys - sorted.