I have a pan X file, with a date field. The dates are formatted as dd Mon 'yy, with Right alignment. The database behaves just as one would expect with sorting, grouping, etc.
But when I click on a record's Date field and hit Enter (to look at the actual entry in the field), the correct entry is there (formatted as mm/dd/yy) but skewed so far to the right that the year value is not visible. Even more disturbing is that when you hit Enter again, to accept the value, an error message appears, viz.,
date( function: illegal date "".
Everything works in the file, and there is no particular problem. But what is happening, and is this an issue to be concerned about?