Hundred Year Date

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

  1. 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
    #1
    1. Advertising

  2. =?Utf-8?B?VGlt?=

    Raterus Guest

    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
    #2
    1. Advertising

  3. =?Utf-8?B?VGlt?=

    Lucas Tam Guest

    =?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 ()
    Please delete "REMOVE" from the e-mail address when replying.
    http://members.ebay.com/aboutme/coolspot18/
     
    Lucas Tam, Aug 11, 2004
    #3
  4. 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
    #4
  5. 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
  6. =?Utf-8?B?VGlt?=

    Mark Rae Guest

    "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
    #6
  7. =?Utf-8?B?VGlt?=

    Raterus Guest

    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:...
    > 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
    #7
  8. =?Utf-8?B?VGlt?=

    Chris Moore Guest

    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: <> <>
    >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
    #8
  9. =?Utf-8?B?VGlt?=

    mikeb Guest

    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: <> <>
    >>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
    #9
  10. =?Utf-8?B?VGlt?=

    amercado

    Joined:
    Aug 14, 2007
    Messages:
    1
    Location:
    Lakeland, Florida
    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.
     
    amercado, Aug 14, 2007
    #10
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Otuatail

    Week of year to full Year

    Otuatail, Dec 8, 2003, in forum: HTML
    Replies:
    4
    Views:
    981
    Toby A Inkster
    Dec 8, 2003
  2. SteveC
    Replies:
    2
    Views:
    452
    SteveC
    Jul 30, 2008
  3. Replies:
    38
    Views:
    944
  4. Ryan Davis

    THREE HUNDRED!

    Ryan Davis, Jun 24, 2009, in forum: Ruby
    Replies:
    45
    Views:
    405
    Eero Saynatkari
    Jun 24, 2009
  5. Veerle
    Replies:
    2
    Views:
    425
    niceguy
    Aug 20, 2003
Loading...

Share This Page