>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com