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

[onez]

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

[Ianpbaker]

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

[Ruxpin]

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

dateadd("m",1,now)

[onez]

thanks for your help.it solve my problem..