>Yeah, I had already sent my reply before I saw Josh's. I'm using a similar solution in a grid in an application to what you're doing. Works fine as long as you're not editing data in the grid ( which I don't allow :-) ).
I discovered an additional problem in testing...if you have header-click-sort on the char date fields, you can forget about a year-ordered sort :)
Using CTOD() for the index works fine, even with 2-digit years (which is all I have space for), if ROLLOVER is set appropriately...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.