What format should I be using when updating a date field in an MsAccess<BR>table, I always get month and day mixed up. I tried using the DanDate<BR>procedure mentionned in this site but I think<BR>this is only for displaying, isn&#039t it ?<BR>Anyway here is my code : sSQL = sSQL & "#" & Session("MyDate)& "#,"<BR><BR>If you look at www.mejoresdatos.cl you&#039ll see that the month and year are<BR>switched, which is fine for American users but not for Chileans.<BR><BR>Thanks for helping me,<BR><BR>jean-luc<BR><BR>www.corobori.com