How to make SqlDate ?

[Ather Ali Shaikh]

Hello All,
I have a textbox for Date Input.
First. It couldbe in ny format.
i.e
MM/dd/yyyy
dd/MM/yyyy
and others
But on database site I have only MM/dd/yyyy

My code works properly with the formats except dd/MM/yyyy

it returns that string is not valid date tiem.

How to resolve this issue ?

Regards
Ather Ali Shaikh

 

[Guest]

Default database bate format is mm/dd/yyyy. All you need to do is ..convert the dates entered in dd/mm/yyyy format to mm/dd/yyyy in your code or use convert function with code "103" to convert the date from dd/mm/yyyy

Details can be found on this in depth post ..
http://www.experts-exchange.com/Databases/Q_20808800.htm

Hope this help

Avnees
MCAD, MCSD.Ne

----- Ather Ali Shaikh wrote: ----

Hello All
I have a textbox for Date Input
First. It couldbe in ny format
i.
MM/dd/yyy
dd/MM/yyy
and other
But on database site I have only MM/dd/yyy

My code works properly with the formats except dd/MM/yyy

it returns that string is not valid date tiem

How to resolve this issue

Regard
Ather Ali Shaik