>Hi,
> I faced a problem that VB function such as CDate keep assume my datevariable in mm/dd/yy format. How could I set the date format in dd/mm/yyyy?
VB is a US product. Therefore, VB will always consider the US format for date value.
You have to format it the way you want!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com