I was working (more like debugging) on this jolly old Access system when something unexpected came up, for my task was to migrate it to Office 2007. Somehow, after months of work on this, let's be polite here, crappy system, I thought i saw it all. I thought this was almost over.
Yet Life has a way to raise the old ghosts of the past.
IIF(
Left([trim_an];1)="H";
"HIVER";
IIF(
Left([TRIM_AN];1)="E";
"ÉTÉ";
"AUTOMNE"
)
)
& " "
& "19"
& Right([TRim_AN];2)
Yep. Y2K is back. Stack up on canned goods and water people, we're going down.
Just needed to share this before i go mad. i need another coffee...