Groups | Search | Server Info | Login | Register

Groups > comp.databases.ms-access > #14505

Re: Converting a 2 digit year to 4 digit year

Show all headers | View raw

петак, 8. март 2002. у 22:36:40 UTC+1, Larry Linson је написао/ла:
> The aircode, if its not obvious, converts two digit years greater than 30 to
> 19xx, and 30 or less to 20xx.
> "Anthony Vitelli" <gul...@yahoo.com> wrote in message
> news:195b73b1.02030...@posting.google.com...
> > The field is just a text field, in which there are 2 numeric digits.
> > They are the last 2 of a year, and I need to convert them to a four
> > digit year. I was wondering if Access (or VBA) had any cool function
> > to check a 2 digit year and then expand it to the correct 4 digit
> > year.
> >
> > Thanks,
> >
> > Anthony
> >
> > "Larry Linson" <larry....@ntpcug.org> wrote in message
> news:<OsWh8.7675$J3....@nwrddc01.gnilink.net>...
> > > And what two digit years you want to convert to what four digit years,
> > > definitely. That is, is "20" to be 1920 or 2020?
> > >
> > > "Rick Brandt" <RBr...@Hunter.Com> wrote in message
> > > news:a68cpv$cg78n$1...@ID-98015.news.dfncis.de...
> > > > "Anthony Vitelli" <gul...@yahoo.com> wrote in message
> > > > news:195b73b1.02030...@posting.google.com...
> > > > > Does anyone have a good way to update a column containing a 2 digit
> > > > > year, and set it to the corresponding 4 digit year?
> > > > >
> > > > > Example: 99 is the value in the column, and I want to set it to
> 1999.
> > > > >
> > > > > Thanks!
> > > >
> > > > Is this a Date field or a Character field that contains text
> representing
> > > a
> > > > date or year? If the former you should know that Access always stores
> > > dates
> > > > exactly the same way. What you "see" is only a display format which
> by
> > > > default follows the date format set in your Windows Control Panel.
> Any
> > > > place where the date will be "seen" you can apply any other valid date
> > > > format.
> > > >
> > > > If the field contains character data then I would need to know exactly
> how
> > > > the entries are formatted to be able to answer.
> > > >
> > > >
Hi. What about 2023

Back to comp.databases.ms-access | Previous | Next | Find similar

Thread

Re: Converting a 2 digit year to 4 digit year Вујадин Bасовић <vuja.was2001@gmail.com> - 2023-04-24 06:01 -0700

csiph-web