Message-ID:

Why are there always boycotts? Shouldn't there be girlcotts too? -- argon on #Linux

devel / comp.databases.ms-access / Re: Converting a 2 digit year to 4 digit year

Re: Converting a 2 digit year to 4 digit year

<71114112-8ffa-4c75-9574-800b3c0484aen@googlegroups.com>

https://www.novabbs.com/devel/article-flat.php?id=627&group=comp.databases.ms-access#627

copy link Newsgroups: comp.databases.ms-access

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: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.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: vuja.was...@gmail.com (Вујадин Bасовић)
Injection-Date: Mon, 24 Apr 2023 13:01:00 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

by: Вујадин Bас - Mon, 24 Apr 2023 13:01 UTC

петак, 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

Subject	Author
Re: Converting a 2 digit year to 4 digit year	Вујадин Bасовић