to save a date in "dd/mm/yyyy" format

[nudrat]

I have a form in ASP, where Date has to display in "dd/mm/yyyy" format. when I am saving that format into database its giving either error message or saving incorrect date. because sql used to insert dates in "dd/mm/yyyy" format.
say if date is 24 sep 2007, in sql it will not save as "24/09/2007", it will be out of script range error and if date is 3 sep 2007 , then sql will treat as 9 March 2007.
please find a solution for that.

Thanks & Regards
Nudrat

[debasisdas]

Hi nudrat

Welcome to TSDN.

Please post all your ASP related questions in the ASP Forum only.


moved tom ASP Forum