I got this one prob about date in ASP.

If i want to display the date as from Wednesday, May 05, 2004 to
2004-05-05, how do i actually do that?
Thanx

I can't test this unfortunately but you might try.....

myDate = "Wednesday, May 05, 2004 "
myDay = day(myDate)
myMonth = Month(myDate)
myYear = year(myDate)
myNewDate = myYear & "-" & myMonth & "-" & myDay

You may have to change month and day to see if they need a 0 in front of them or not as well.

Sorry but it come out nothing.My code is like this:

mydate= ConvertDate(FormatDateTime(Date(), 1))
myday=Day(mydate)
mymonth=Month(mydate)
myyear=Year(mydate)
cutOffdate=myYear & "-" & myMonth & "-" & myDay
----------------------------------------------------------------
the output for the "ConvertDate(FormatDateTime(Date(), 1))"
is Wednesday, May 05, 2004.
Please help me
thanx

Are you actually using.... mydate= ConvertDate(FormatDateTime(Date(), 1))??

Because if you are.....

mydate= Date()
myday=Day(mydate)
mymonth=Month(mydate)
myyear=Year(mydate)
cutOffdate=myYear & "-" & myMonth & "-" & myDay

If you are stuck with this format Wednesday, May 05, 2004 then you might try this....
myDate = "Wednesday, May 05, 2004"
arrDate = split(myDate," ")
myDate = CDate(left(arrDate(2),2) & "-" & arrDate(1) & "-" & arrDate(3))
myday=Day(mydate)
mymonth=Month(mydate)
myyear=Year(mydate)
cutOffdate=myYear & "-" & myMonth & "-" & myDay

Thanx very much.
I try and can already.
Thanx again