Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Hundred Year Date

Reply
Thread Tools

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
 
Reply With Quote
 
 
 
 
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" <> 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

 
Reply With Quote
 
 
 
 
Lucas Tam
Guest
Posts: n/a
 
      08-11-2004
=?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/
 
Reply With Quote
 
=?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" <> 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

>

 
Reply With Quote
 
=?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" <> 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

>

 
Reply With Quote
 
Mark Rae
Guest
Posts: n/a
 
      08-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.

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


 
Reply With Quote
 
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
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

> >

 
Reply With Quote
 
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
--------------------
>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

>>

>



 
Reply With Quote
 
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.

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
 
Reply With Quote
 
amercado amercado is offline
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Antec Nine Hundred Case Silverstrand Front Page News 0 10-08-2006 08:14 PM
Firefox using 2 hundred megs memmory useage ???? Home Theatre Guy Firefox 15 07-30-2006 08:26 PM
Anybody remember, Run Buddy Run and Second Hundred Years? Tom McCafferty DVD Video 5 10-02-2004 09:15 PM
Hundred's of double shortcuts on system? Baalrog Computer Support 1 09-05-2004 01:39 PM
Date, date date date.... Peter Grison Java 10 05-30-2004 01:20 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57