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 messagenews:<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?
1999.Example: 99 is the value in the column, and I want to set it to
Thanks!
representingIs this a Date field or a Character field that contains text
bya
date or year? If the former you should know that Access always storesdates
exactly the same way. What you "see" is only a display format which
Anydefault follows the date format set in your Windows Control Panel.
place where the date will be "seen" you can apply any other valid date format.
howIf the field contains character data then I would need to know exactly
the entries are formatted to be able to answer.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 297 |
Nodes: | 16 (2 / 14) |
Uptime: | 24:38:30 |
Calls: | 6,668 |
Calls today: | 2 |
Files: | 12,216 |
Messages: | 5,337,563 |