петак, 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" <[email protected]> wrote in message news:[email protected]...

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" <[email protected]> wrote in message

news:<OsWh8.7675$[email protected]>...

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" <[email protected]> wrote in message news:a68cpv$cg78n$[email protected]...

"Anthony Vitelli" <[email protected]> wrote in message news:[email protected]...

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)