i have come across some very strange beheaviour using date in sql server and VS.
i am using date as follow: DD/MM/YYYY, this get accepted by the sqlserver when you input this date from a VS form. however, when you pass some date to the sql (for example to compare to dates) it considers as MM/DD/YYYY. i don't know what's happening.
all my settings in the system is set to DD/MM/YYYY.
is there any way that you can set to make both sides understand one format
anyone can help please?