Converting As400 date formats YYMMDD and CYYMMDD for use in Access
Posted on 2012-03-11
I need to convert dates imported from an AS400 server into an Access 2003 database. The dates are both pre-2000 and post 2000 with a Century notation on the post-2000 years.
I'm not a programmer, but I do know how to apply and use Module code.
I would like Module code to handle either case:
991204 needs to become 12/04/1999 and
1021204 needs to convert to 12/04/2002
I've found several examples - but none seem to handle both pre- and post-2000.
Is this possible??
I have a report with 12 different dates that need to be converted and also need to work in calculations, and I am really stuck...
Thanks in advance..