I have imported an excel file into a Lotus Notes database using LotusScript. One of the columns in my view (which displays the imported data) shows a date. If the year is greater than 2000, it is shown with 4 digits e.g. 2001. However if the year is less than 2000 the year is displayed with just 2 digits e.g. 99. Does anybody know why this is? The date is contained in a text field. The column uses the "Date / Time" style with "Show Only month, day and year". Display Time is not selected.
In your column properties, look at the 4th tab (Advanced Format). You say you have "Date/Time" selected, and "Display Date" selected. Nex to that in the "Special" field, have you ticked "Show 4 digit year for 21st century"? If so, 20th century dates will show with 2 digits, 21st century ones with 4.
I remember when this feature was added, and thinking how cool it was. God, I feel old!