How can i change the format of this date:
'23-May-03' to '230403' or '23/04/03'
For a hole column in a table using asp.net

This is a classic ASP forum, for the best solutions .net issues should go in the .net area

BTW should '23/04/03' be '23/05/03'
    and '230403' be '230503'
As May is the 5th month not the 4th, my appolgies if I have assumed incorrectly.

Anyhow in classic ASP using vbScript you could:
-----------cut n paste-------------
   dim d,nd,td
   d = "23-May-03"
   response.write "'" & dateValue(d) & "'" & "<br>"

   nd =dateValue(d)
   td = Replace(nd, "/", "")
   response.write "'" & td & "'"
-----------------------------------



Wind is your friend
Matt