Hundred Year Date

Discussion in 'ASP .Net' started by =?Utf-8?B?VGlt?=, Aug 11, 2004.

1. =?Utf-8?B?VGlt?=Guest

Does anyone know how to convert a date to the hundred year date format.
For example, how would i convert 8/11/2004 to its hundred year date format.
Thanks!

Tim

=?Utf-8?B?VGlt?=, Aug 11, 2004

2. RaterusGuest

I'm not familiar with the "hundred year date format", What would the end format look like for '8/11/2004' ?

"Tim" <> wrote in message news:...
> Does anyone know how to convert a date to the hundred year date format.
> For example, how would i convert 8/11/2004 to its hundred year date format.
> Thanks!
>
> Tim

Raterus, Aug 11, 2004

3. Lucas TamGuest

=?Utf-8?B?VGlt?= <> wrote in
news::

> Does anyone know how to convert a date to the hundred year date
> format. For example, how would i convert 8/11/2004 to its hundred year
> date format. Thanks!

You can use the FormatDateTime or Format function.

--
Lucas Tam ()

Lucas Tam, Aug 11, 2004
4. =?Utf-8?B?VGlt?=Guest

The hundred year date for 8/11/2004 would be 38209

"Raterus" wrote:

> I'm not familiar with the "hundred year date format", What would the end format look like for '8/11/2004' ?
>
> "Tim" <> wrote in message news:...
> > Does anyone know how to convert a date to the hundred year date format.
> > For example, how would i convert 8/11/2004 to its hundred year date format.
> > Thanks!
> >
> > Tim

>

=?Utf-8?B?VGlt?=, Aug 11, 2004
5. =?Utf-8?B?VGlt?=Guest

The hundred year date for 8/11/2004 would be 38209

"Raterus" wrote:

> I'm not familiar with the "hundred year date format", What would the end format look like for '8/11/2004' ?
>
> "Tim" <> wrote in message news:...
> > Does anyone know how to convert a date to the hundred year date format.
> > For example, how would i convert 8/11/2004 to its hundred year date format.
> > Thanks!
> >
> > Tim

>

=?Utf-8?B?VGlt?=, Aug 11, 2004
6. Mark RaeGuest

"Tim" <> wrote in message
news:...

> Does anyone know how to convert a date to the hundred year date format.
> For example, how would i convert 8/11/2004 to its hundred year date

format.

"Hundred year format"??? What on earth is that?

Mark Rae, Aug 11, 2004
7. RaterusGuest

I do believe this is what you are after

Dim dt As DateTime = #8/11/2004#
Dim d As Long

"Tim" <> wrote in message news:...
> The hundred year date for 8/11/2004 would be 38209
>
> "Raterus" wrote:
>
> > I'm not familiar with the "hundred year date format", What would the end format look like for '8/11/2004' ?
> >
> > "Tim" <> wrote in message news:...
> > > Does anyone know how to convert a date to the hundred year date format.
> > > For example, how would i convert 8/11/2004 to its hundred year date format.
> > > Thanks!
> > >
> > > Tim

> >

Raterus, Aug 11, 2004
8. Chris MooreGuest

I'm just curious, but does anybody know how 8/11/2004 becomes 38209? What's the basis of this hundred year format?

Chris
--------------------
>Thread-Topic: Hundred Year Date
>X-WBNR-Posting-Host: 68.20.202.149
>From: =?Utf-8?B?VGlt?= <>
>References: <> <>
>Subject: Re: Hundred Year Date
>Date: Wed, 11 Aug 2004 13:07:03 -0700
>Lines: 13
>Message-ID: <>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.dotnet.framework.aspnet
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:253709
>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
>
>The hundred year date for 8/11/2004 would be 38209
>
>"Raterus" wrote:
>
>> I'm not familiar with the "hundred year date format", What would the end format look like for '8/11/2004' ?
>>
>> "Tim" <> wrote in message news:...
>> > Does anyone know how to convert a date to the hundred year date format.
>> > For example, how would i convert 8/11/2004 to its hundred year date format.
>> > Thanks!
>> >
>> > Tim

>>

>

Chris Moore, Aug 13, 2004
9. mikebGuest

Chris Moore wrote:
> I'm just curious, but does anybody know how 8/11/2004 becomes 38209? What's the basis of this hundred year format?

It's the number of days since some point near the start of 1900.

See the docs for DateTime.ToOADate().

There may be a bit of discrepancy - the OP said that 8/11/2004 should be
38209.

ToOADate() returns 38210 for that date.

>
> Chris
> --------------------
>
>>Thread-Topic: Hundred Year Date
>>X-WBNR-Posting-Host: 68.20.202.149
>>From: =?Utf-8?B?VGlt?= <>
>>References: <> <>
>>Subject: Re: Hundred Year Date
>>Date: Wed, 11 Aug 2004 13:07:03 -0700
>>Lines: 13
>>Message-ID: <>
>>MIME-Version: 1.0
>>Content-Type: text/plain;
>> charset="Utf-8"
>>Content-Transfer-Encoding: 7bit
>>X-Newsreader: Microsoft CDO for Windows 2000
>>Content-Class: urn:content-classes:message
>>Importance: normal
>>Priority: normal
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>>Newsgroups: microsoft.public.dotnet.framework.aspnet
>>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
>>Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:253709
>>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
>>
>>The hundred year date for 8/11/2004 would be 38209
>>
>>"Raterus" wrote:
>>
>>
>>>I'm not familiar with the "hundred year date format", What would the end format look like for '8/11/2004' ?
>>>
>>>"Tim" <> wrote in message news:...
>>>
>>>>Does anyone know how to convert a date to the hundred year date format.
>>>>For example, how would i convert 8/11/2004 to its hundred year date format.
>>>>Thanks!
>>>>
>>>>Tim
>>>

>
>

--
mikeb

mikeb, Aug 13, 2004

Joined:
Aug 14, 2007
Messages:
1