Insert date to SQL server creates error

[Ross Francis]

Hi All, Thanks in Advance!

I am attempting to insert a date into a SQL 2000 datetime
field from an asp form. The problem that I am encountering
is that the date is being type dd/mm/yy (which is fine as
I am in Australia), but is being submitted by the form as
mm/dd/yy. Any assistance in resolving this would be
appreciated.

Thanks

[Bob Barrows]

Ross Francis wrote:

> Hi All, Thanks in Advance!
>
> I am attempting to insert a date into a SQL 2000 datetime
> field from an asp form. The problem that I am encountering
> is that the date is being type dd/mm/yy (which is fine as
> I am in Australia), but is being submitted by the form as
> mm/dd/yy. Any assistance in resolving this would be
> appreciated.
>
> Thanks

Always supply dates to your database in ISO format: yyyymmdd. This will
avoid all ambiguity.