I have MS SQL on the local development server and on the production server. My local server's DateTime format is "mm / dd / yyyy", but the format on the production server is "dd / mm / yyyy". Everything worked fine on my local server, but when I try to enter a date, for example, "05/31/2010" on my production server, the Validation model generated an error "The value" 05/31/2010 "is invalid for ....", so as a month it cannot be more than 12. I do not want to change the DateTime on any of the servers. Can some body tell me how to get rid of this problem so that everything works fine on both of my servers?
source
share