i am using vb calender.
and i want the date format dd/mm/yyyy

but calendar gives it in mm/dd/yyyy.
i also tried the format function -
mydate= format(calendar1.value, "dd/mm/yyyy")

still problem is same.

if u know the solution that how to get the date in dd/mm/yyyy plz send me.

did you define "mydate" as string?

format(date,"dd/mm/yyyy") works fine for me in the immediate window

"There are two ways to write error-free programs. Only the third one works."
Unknown