hai everyone....

i have problem with the date.i use active x contol calendar to ask user insert the date.it follow the client computer that is MM/DD/YY but i also using some date function.it's formula is reverse from active x control-DD/MM/YY.it give big problem to me when i want to add a number to the date because it's not in the same formula.

so i want to know if there's any function that can convert date from MM/DD/YY to DD/MM/YY.i really need your help.i'm stuck of this......
thanks