Date Convert

[Nebooaw]

Hi, how can i convert a d-m-y date to a m-d-y date with a function?

i have the following string... "13-10-2004 11:28:13" which needs converting to "10-13-2004 11:28:13"

Can anyone help?


Kind regards

 

[PHV]

Something like this ?
d="13-10-2004 11:28:13"
MsgBox Mid(d,4,3) & Left(d,3) & Mid(d,7)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Nebooaw]

thanks for replying - think you way is better than...

dim datearray, dd, mm, yyyy
datearray = split(Request.Form("lastmodified"), "/")
dd = Datearray(0)
mm = Datearray(1)
yyyy = Datearray(2)

Cheers,

Nebooaw