«

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

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:F2E26CE3-22B1-451C-A310-...
> 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?= <> wrote in
news:F2E26CE3-22B1-451C-A310-:

> 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 ()
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

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:F2E26CE3-22B1-451C-A310-...
> > 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
>

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:F2E26CE3-22B1-451C-A310-...
> > 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
>

"Tim" <> wrote in message
news:F2E26CE3-22B1-451C-A310-...

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

I do believe this is what you are after

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

"Tim" <> wrote in message news:C03C5834-596E-4C71-97CC-...
> 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:F2E26CE3-22B1-451C-A310-...
> > > 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
> >

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
>thread-index: AcR/3sSk1DSrctEoTmCz2HV71rYN/w==
>X-WBNR-Posting-Host: 68.20.202.149
>From: =?Utf-8?B?VGlt?= <>
>References: <F2E26CE3-22B1-451C-A310-> <>
>Subject: Re: Hundred Year Date
>Date: Wed, 11 Aug 2004 13:07:03 -0700
>Lines: 13
>Message-ID: <C03C5834-596E-4C71-97CC->
>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:F2E26CE3-22B1-451C-A310-...
>> > 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 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
>>thread-index: AcR/3sSk1DSrctEoTmCz2HV71rYN/w==
>>X-WBNR-Posting-Host: 68.20.202.149
>>From: =?Utf-8?B?VGlt?= <>
>>References: <F2E26CE3-22B1-451C-A310-> <>
>>Subject: Re: Hundred Year Date
>>Date: Wed, 11 Aug 2004 13:07:03 -0700
>>Lines: 13
>>Message-ID: <C03C5834-596E-4C71-97CC->
>>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:F2E26CE3-22B1-451C-A310-...
>>>
>>>>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

[amercado]

Hey guys, the best way to convert a date to a Hundred-Year format is with the following formula: result = date(datefield + (days((date('1899-12-31')))))
The base date is Dec 31, 1899. the formula works for SQL, Queries, and RPGILE programming languages. I would assume it would still apply to any other programming language, you should follow the specific format for those languages.