How to transform a date-string in classic asp

Question

I'm a little blockheaded right now…

I have a date string in european format dd.mm.yyyy and need to transform it to mm.dd.yyyy with classic ASP. Any quick ideas?

Answer 1

If its always in that format you could use split

d = split(".","dd.mm.yyyy")
s = d(1) & "." & d(0) & "." & d(2)

this would allow for dates like 1.2.99 as well

Answer 2

Dim arrParts() As String
Dim theDate As Date

arrParts = Split(strOldFormat, ".")
theDate = DateTime.DateSerial(parts(2), parts(1), parts(0))

strNewFormat = Format(theDate, "mm.dd.yyyy")