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/Data...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