Velocity Reviews > Hundred Year Date

Hundred Year Date

=?Utf-8?B?VGlt?=
Guest
Posts: n/a

 08-11-2004
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
Guest
Posts: n/a

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

"Tim" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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

Lucas Tam
Guest
Posts: n/a

 08-11-2004
=?Utf-8?B?VGlt?= <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> 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 ((E-Mail Removed))

=?Utf-8?B?VGlt?=
Guest
Posts: n/a

 08-11-2004
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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> > 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?=
Guest
Posts: n/a

 08-11-2004
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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> > 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

>

Mark Rae
Guest
Posts: n/a

 08-11-2004
"Tim" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

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

Raterus
Guest
Posts: n/a

 08-11-2004
I do believe this is what you are after

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

"Tim" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> > > 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
Guest
Posts: n/a

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

Chris
--------------------
>X-WBNR-Posting-Host: 68.20.202.149
>From: =?Utf-8?B?VGlt?= <(E-Mail Removed)>
>References: <(E-Mail Removed)> <(E-Mail Removed)>
>Subject: Re: Hundred Year Date
>Date: Wed, 11 Aug 2004 13:07:03 -0700
>Lines: 13
>Message-ID: <(E-Mail Removed)>
>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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>> > 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
Guest
Posts: n/a

 08-13-2004
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.

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

ToOADate() returns 38210 for that date.

>
> Chris
> --------------------
>
>>X-WBNR-Posting-Host: 68.20.202.149
>>From: =?Utf-8?B?VGlt?= <(E-Mail Removed)>
>>References: <(E-Mail Removed)> <(E-Mail Removed)>
>>Subject: Re: Hundred Year Date
>>Date: Wed, 11 Aug 2004 13:07:03 -0700
>>Lines: 13
>>Message-ID: <(E-Mail Removed)>
>>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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>>>
>>>>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

Junior Member
Join Date: Aug 2007
Location: Lakeland, Florida
Posts: 1

 08-14-2007
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.