Date conversion problem

[Hugh Welford]

Hi...
I am in UK using XP with date format set to dd/mm/yy. I am running an asp
site from a server in USA, which is returning the date from a database field
retrieved as objrec("todate") in US format mm/dd/yy.

To rectify this so as not to confuse visitors to the site I am trying to get
the date displayed as dd month yy , e.g. 25 January 04 by using the format
function format(objrec("todate"), "d-mmmm-yy"). This returns me a VBScript
runtime error "Type mismatch: 'format' "

The data base field "todate" is stored in short date format, which should be
OK shouldnt it?

Can someone explain what I am doing wrong... Thanks for your help Hugh

 

[Aaron Bertrand [MVP]]

http://www.aspfaq.com/2260
http://www.aspfaq.com/2313

 

[Brynn]

Function dateConv(theDate)
Dim arr, newdate: arr=split(theDate,"/")
newdate = arr(1) & "/" & arr(0) & "/" & arr(2)
dateConv = day(newdate) & " " & monthname(month(newdate)) & "
" & year(newdate)
End FUnction

Hi...
I am in UK using XP with date format set to dd/mm/yy. I am running an asp
site from a server in USA, which is returning the date from a database field
retrieved as objrec("todate") in US format mm/dd/yy.

To rectify this so as not to confuse visitors to the site I am trying to get
the date displayed as dd month yy , e.g. 25 January 04 by using the format
function format(objrec("todate"), "d-mmmm-yy"). This returns me a VBScript
runtime error "Type mismatch: 'format' "

The data base field "todate" is stored in short date format, which should be
OK shouldnt it?

Can someone explain what I am doing wrong... Thanks for your help Hugh

Brynn
www.coolpier.com

I participate in the group to help give examples of code.
I do not guarantee the effects of any code posted.
Test all code before use!

 

[Hugh Welford]

Thanks for your help everyone

Function dateConv(theDate)
Dim arr, newdate: arr=split(theDate,"/")
newdate = arr(1) & "/" & arr(0) & "/" & arr(2)
dateConv = day(newdate) & " " & monthname(month(newdate)) & "
" & year(newdate)
End FUnction



Brynn
www.coolpier.com

I participate in the group to help give examples of code.
I do not guarantee the effects of any code posted.
Test all code before use!