date (MM/DD/YY & DD/MM/YY)

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

If you are using asp you can use the formatdatetime function or if it is in VB you can use the format function

eg. myconverteddate = format(mydate,"dd/mm/yyyy")

Hope this helps

ian

If you want to add to dates as well probably best to use the dateadd function

dateadd("m",1,now)

thanks for your help.it solve my problem..