Is there any way i can change the date format to dd/mm/yyyy?<BR><BR>Must the date format be the same to do a sql statement?
i believe it is up to the local computer if the format will be in mm/dd/yy or dd/mm/yy.
also you could just write a function to spit it out in that date, but it should be for display ONLY, if you are comparing dates or using them in sql statements, keep them in the standard VBS format.
standard VBS format? but one of the date is taken from the user. You are right that i can get the system day to be dd/mm/yyyy but the problem is it willl remove the zeros. I need the zeros too. Any idea?