Originally posted by gilly
I need to convert this line to date format dd,mm,yyyy

Whats the correct syntax?

shipdt = Mid (sstringtobreakdown, 23, 8)
i don't see where you're getting that from ?