Cast from string "28/09/2006" to type 'Date' is not valid.

[bpavan_2]

help me to sort out this problem i had taken a date time picker and changing the format to dd/mm/yy :((

sdf

[Sage]

set dateformat dmy

[Michael P Butler]

bpavan_2 wrote:

help me to sort out this problem i had taken a date time picker and changing the format to dd/mm/yy

Are you wanting to do this in .NET code or in SQL. In .NET you'll need to use the ParseExact method of the DateTime class[^]

Michael CP Blog [^] Development Blog [^]

[Hesham Amin]

If you use SqlCommand with parameters..This an solve alot of problems like formats and sql injection.