formatting dates

treasacrowe · October 20th, 2004, 05:21 AM

hi does anybody know how to change the format of a date from american, to european, ie from 10/20/04 to 20/10/04 automatically? thanks,
Treasa

treasacrowe · October 20th, 2004, 05:26 AM

i got it working, thanks!

happygv · October 20th, 2004, 10:11 AM

Was that solution similar to this?

Code:

select convert(varchar(10),getdate(),103)

Cheers!

_________________________
- Vijay G
Strive for Perfection

mat41 · October 20th, 2004, 06:52 PM

I find these functions handy:

------------------cut n paste----------------
  function ddmmyyyy(varDate)
     ddmmyyyy = Day(DateValue(varDate)) & "/" & Month(DateValue(varDate)) & "/" & Year(DateValue(varDate))
  end function

  function mmddyyyy(varDate)
     mmddyyyy = Month(DateValue(varDate)) & "/" & Day(DateValue(varDate)) & "/" & Year(DateValue(varDate))
  end function

  response.write ddmmyyyy(now) & " = dd/mm/yyyy format<Br>"

  response.write mmddyyyy(now) & " = mm/dd/yyyy format<Br>"
-----------------------------------------

Wind is your friend
Matt