>I have a datagrid with two columns columns, EffectiveDate and Expiry Date, both columns have the format set to "yy/mm/dd" but when I enter "00/03/31" and "01/03/31" into the columns respectively the values appear as "00/03/31" (correct) and "31/01/03" (wrong). Why is this and how can I fix it?

Set your format to have yyyy and you won't have any problem.