convert to date dd,mm,yyyy

[gilly]

I need to convert this line to date format dd,mm,yyyy

Whats the correct syntax?

shipdt = Mid (sstringtobreakdown, 23, 8)