convert to date dd,mm,yyyy

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

Whats the correct syntax?

shipdt = Mid (sstringtobreakdown, 23, 8)

Use the format() function

example:

format (sString, "mmddyyyy")

VB Code:

shipdt = Format(shipdt, "dd/mm/yyyy")

What format is"shipdt" in?

If it is just an 8 char string (eg 23022001)this might help:



http://www.vbforums.com/showthread.p...hreadid=125957

if it is an 8 char string try this:

Code:

---

Dim temp As String

Temp = Mid (sstringtobreakdown, 23, 8)
shipdt = Left(Temp, 2) & "/" & Mid(Temp, 3, 2) & "/" & Right(Temp, 4)

---

Quote:

---

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 :eek: ?

Quote:

---

Originally posted by da_silvy


i don't see where you're getting that from :eek: ?

---

It's a long story;)

It started off in the ASP section.

ahh ok. not up to the asp forum yet,

i'm going to knock over 4000 in vbq&a then move onto others in search of more threads :p