Date Woes

[Kevin Vaughn]

I am trying to convert a date from this format:

yyyymmddHHMMSS.mmmmmmsUUU

to a format that ASP.NET (VB.NET) understands.

The above date format is used by the WMI datetime type. I don't care about
the mmmmmmsUUU part, as that counts milliseconds and microseconds. The sUUU
is a three digit offset indicating the number of minutes that the
originating time zone deviates from UTC. Other than that, the format is
pretty self explanatory.

(more info here:
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/[/url]
date_and_time_format.asp)

I can imagine all kinds of weird, contorted, or otherwise convoluted ways of
formatting this date, but I wanted to check and see if there's an better way
before I go off and spend gobs of time reinventing the wheel.

Any ideas?

-Kevin

[Daniel Bass]

the easiest way i've seen would probably be:

Dim myDate as Date

myDate = yearstring & "/" & monthstring & "/" & daystring & " " & hourstring
& ":" & minstring

which means you'll have to split up the string somewhere into those
strings...

good luck


"Kevin Vaughn" <kevin.vaughn@ttu.edu> wrote in message
news:vg8cv9p9t041f2@corp.supernews.com...

> I am trying to convert a date from this format:
>
> yyyymmddHHMMSS.mmmmmmsUUU
>
> to a format that ASP.NET (VB.NET) understands.
>
> The above date format is used by the WMI datetime type. I don't care

about

> the mmmmmmsUUU part, as that counts milliseconds and microseconds. The

sUUU

> is a three digit offset indicating the number of minutes that the
> originating time zone deviates from UTC. Other than that, the format is
> pretty self explanatory.
>
> (more info here:
>

[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/[/url]

> date_and_time_format.asp)
>
> I can imagine all kinds of weird, contorted, or otherwise convoluted ways

of

> formatting this date, but I wanted to check and see if there's an better

way

> before I go off and spend gobs of time reinventing the wheel.
>
> Any ideas?
>
> -Kevin
>
>

[Kevin Vaughn]

That's really exactly what I was looking for. Thank you for your time.

-Kevin

"Daniel Bass" <danielbass@postmaster.co.uk> wrote in message
news:uUYpJzWQDHA.3768@tk2msftngp13.phx.gbl...

> the easiest way i've seen would probably be:
>
> Dim myDate as Date
>
> myDate = yearstring & "/" & monthstring & "/" & daystring & " " &

hourstring

> & ":" & minstring
>
> which means you'll have to split up the string somewhere into those
> strings...
>
> good luck
>
>
> "Kevin Vaughn" <kevin.vaughn@ttu.edu> wrote in message
> news:vg8cv9p9t041f2@corp.supernews.com...

> > I am trying to convert a date from this format:
> >
> > yyyymmddHHMMSS.mmmmmmsUUU
> >
> > to a format that ASP.NET (VB.NET) understands.
> >
> > The above date format is used by the WMI datetime type. I don't care

> about

> > the mmmmmmsUUU part, as that counts milliseconds and microseconds. The

> sUUU

> > is a three digit offset indicating the number of minutes that the
> > originating time zone deviates from UTC. Other than that, the format is
> > pretty self explanatory.
> >
> > (more info here:
> >

>

[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/[/url]

> > date_and_time_format.asp)
> >
> > I can imagine all kinds of weird, contorted, or otherwise convoluted

ways

> of

> > formatting this date, but I wanted to check and see if there's an better

> way

> > before I go off and spend gobs of time reinventing the wheel.
> >
> > Any ideas?
> >
> > -Kevin
> >
> >

>
>

[David Waz]

Regular Expressions are GREAT for this kind of parsing...
Concise, easy to change and understand...

>-----Original Message-----
>I am trying to convert a date from this format:
>
>yyyymmddHHMMSS.mmmmmmsUUU
>
>to a format that ASP.NET (VB.NET) understands.
>
>The above date format is used by the WMI datetime type.

I don't care about

>the mmmmmmsUUU part, as that counts milliseconds and

microseconds. The sUUU

>is a three digit offset indicating the number of minutes t