X-Received: by 2002:a05:6214:4a51:b0:5ef:5f68:83ef with SMTP id ph17-20020a0562144a5100b005ef5f6883efmr2443610qvb.2.1682341260862; Mon, 24 Apr 2023 06:01:00 -0700 (PDT)
X-Received: by 2002:a05:622a:1826:b0:3ef:499a:dd95 with SMTP id t38-20020a05622a182600b003ef499add95mr4518619qtc.7.1682341260576; Mon, 24 Apr 2023 06:01:00 -0700 (PDT)
Path: csiph.com!news.mixmin.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-access
Date: Mon, 24 Apr 2023 06:01:00 -0700 (PDT)
In-Reply-To: <I9ai8.468$qg1.51@nwrddc04.gnilink.net>
Injection-Info: google-groups.googlegroups.com; posting-host=109.92.149.5; posting-account=Xvu66QoAAAAcTkmyhUUy75QCyulcmDsz
NNTP-Posting-Host: 109.92.149.5
References: <195b73b1.0203070951.14e20190@posting.google.com> <a68cpv$cg78n$1@ID-98015.news.dfncis.de> <OsWh8.7675$J3.5628@nwrddc01.gnilink.net> <195b73b1.0203080853.7d612ac0@posting.google.com> <I9ai8.468$qg1.51@nwrddc04.gnilink.net>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <71114112-8ffa-4c75-9574-800b3c0484aen@googlegroups.com>
Subject: Re: Converting a 2 digit year to 4 digit year
From: =?UTF-8?B?0JLRg9GY0LDQtNC40L0gQtCw0YHQvtCy0LjRmw==?= <vuja.was2001@gmail.com>
Injection-Date: Mon, 24 Apr 2023 13:01:00 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Xref: csiph.com comp.databases.ms-access:14505

=D0=BF=D0=B5=D1=82=D0=B0=D0=BA, 8. =D0=BC=D0=B0=D1=80=D1=82 2002. =D1=83 22=
:36:40 UTC+1, Larry Linson =D1=98=D0=B5 =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=
=B0=D0=BE/=D0=BB=D0=B0:
> 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 dig=
it
> > > > > 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 stor=
es
> > > 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 d=
ate
> > > > format.
> > > >
> > > > If the field contains character data then I would need to know exac=
tly
> how
> > > > the entries are formatted to be able to answer.
> > > >
> > > >
Hi. What about 2023