Date Format

[ekendricks]

I'm trying to return a date stored in the database as "07/13/2003", viewable as "July 13, 2003". Using the script below I get Saturday,July 13, 2003. I need to drop the day of the week.

<% response.write FormatDateTime(x_DOB,1) %>

Substituting the "1" for another variable or using the long vb format does not correct the problem. My understanding is that "1" should return the format I want regardless of how the persons computer data format is set.

Thanks

ELK

[Rob]

I don't know why you are getting the day of the week, but it must be down to your regional settings (on the server)

I would split the date on the commas like this:-

Code: Select all

<%
datearray = Split(formatdatetime(now(),1),",")
myDate = datearray(1) & datearray(2)
Response.write myDate
%>

[D3mon]

Are you using SQL?
If so, why not get SQL to return the correct date format. Much quicker than processing the string with ASP

[CactusJack]

<blockquote id="quote"><font size="1" face="geneva, verdana, arial" id="quote">quote:<hr height="1" noshade id="quote">Originally posted by ekendricks

I'm trying to return a date stored in the database as "07/13/2003", viewable as "July 13, 2003". Using the script below I get Saturday,July 13, 2003. I need to drop the day of the week.

<% response.write FormatDateTime(x_DOB,1) %>

Substituting the "1" for another variable or using the long vb format does not correct the problem. My understanding is that "1" should return the format I want regardless of how the persons computer data format is set.

Thanks

ELK
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">
I tend to do this by using a function called "FriendlyDate" or something similar.. each date is then shown as
FriendlyDate(theDate)
Our function can then control date formatting, I just prefer this over letting regional settings etc determine how the date looks, and sometime I am short on space and want 1 Jun 2003 etc.

Its fairly simple code to write the function. Let us know if you need example code.