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)

[Supester]

Use the format() function

example:

format (sString, "mmddyyyy")

[Hack]

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

[Mark Sreeves]

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

[darre1]

if it is an 8 char string try this:

Dim temp As String

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

[da_silvy]

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 ?

[Mark Sreeves]

Originally posted by da_silvy


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

It's a long story

It started off in the ASP section.

[da_silvy]

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