Adding to year on input file

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Meyer1228
    #1

    Adding to year on input file

    We're converting an old database using text files for input and output.
    Their solution for Y2K has 48 years subtracted from the date field.. Our
    input now has the year field with 48 years less (i.e. 2000 is 1952). In VB,
    how do we add 48 years?


    Tags: None
    • Meyer1228
      #2
      Re: Adding to year on input file

      Also - the year is a 2-digit year! So we have to include the century then
      subtract 48 years. (Everything is after 2000 fortunately).

      "Meyer1228" <kathy@ecsnj.co m> wrote in message
      news:1esMd.5310 $ya6.3705@trndn y01...[color=blue]
      > We're converting an old database using text files for input and output.
      > Their solution for Y2K has 48 years subtracted from the date field.. Our
      > input now has the year field with 48 years less (i.e. 2000 is 1952). In[/color]
      VB,[color=blue]
      > how do we add 48 years?
      >
      >[/color]


        Comment

        • Rick Rothstein
          #3
          Re: Adding to year on input file

          > Also - the year is a 2-digit year! So we have to include the century
          then[color=blue]
          > subtract 48 years. (Everything is after 2000 fortunately).
          >
          > "Meyer1228" <kathy@ecsnj.co m> wrote in message
          > news:1esMd.5310 $ya6.3705@trndn y01...[color=green]
          > > We're converting an old database using text files for input and[/color][/color]
          output.[color=blue][color=green]
          > > Their solution for Y2K has 48 years subtracted from the date field..[/color][/color]
          Our[color=blue][color=green]
          > > input now has the year field with 48 years less (i.e. 2000 is 1952).[/color][/color]
          In[color=blue]
          > VB,[color=green]
          > > how do we add 48 years?[/color][/color]

          I'm not sure where in the process you are doing this, but I'm guessing
          the DateAdd function may be what you are looking for.

          Rick - MVP

            Comment

            • Meyer1228
              #4
              Re: Adding to year on input file

              Thanks - That sounds like what I'll need.

              "Rick Rothstein" <rickNOSPAMnews @NOSPAMcomcast. net> wrote in message
              news:s9idncWwuL o_zp_fRVn-1A@comcast.com. ..[color=blue][color=green]
              > > Also - the year is a 2-digit year! So we have to include the century[/color]
              > then[color=green]
              > > subtract 48 years. (Everything is after 2000 fortunately).
              > >
              > > "Meyer1228" <kathy@ecsnj.co m> wrote in message
              > > news:1esMd.5310 $ya6.3705@trndn y01...[color=darkred]
              > > > We're converting an old database using text files for input and[/color][/color]
              > output.[color=green][color=darkred]
              > > > Their solution for Y2K has 48 years subtracted from the date field..[/color][/color]
              > Our[color=green][color=darkred]
              > > > input now has the year field with 48 years less (i.e. 2000 is 1952).[/color][/color]
              > In[color=green]
              > > VB,[color=darkred]
              > > > how do we add 48 years?[/color][/color]
              >
              > I'm not sure where in the process you are doing this, but I'm guessing
              > the DateAdd function may be what you are looking for.
              >
              > Rick - MVP
              >[/color]


                Comment

                Previous template Next
                Working...