Date format changed in DB

Hi experts
i have an old classic ASP application that was working perfectly, lately this application was moved to a new 2014 server and iis 8, the application still working fine but, the application accept dd/mm/yyyy date, but when its added to the database its added as mm/dd/yyyy if the d<10 and dd/mm/yyy if the d>=10
i checked the location and date format for the server and it was dd/mm/yyyy, and the database didn't changed since the old server.
i searched the net and found the i need to change the iis culture under GLOBALIZATION, but i don't know what to choose even if i chose my country still i am facing the same issue.
any suggestion

LVL 1

AZZA-KHAMEESAsked: 2015-07-15

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with Premium. Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 57

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented: 2015-07-15

always try save ur "date" in the format of mm/dd/yyyy instead of dd/mm/yyyy

LVL 90

David Johnson, CD, MVPOwnerCommented: 2015-07-15

Only the US uses mm/dd/yyyy and the rest of the world uses dd/mm/yyyy or yyyy/mm/dd so set your locale to anywhere except the US and don't use strings but a datetime object.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

LVL 1

AZZA-KHAMEESAuthor Commented: 2015-07-16

thank you for the reply, i already changed the country to different country, but still nothing happened, also the field already datatime formate, any other suggestion

LVL 57

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented: 2015-07-16

you can post your scripts of adding records and we will help diagnose accordingly.

LVL 1

AZZA-KHAMEESAuthor Commented: 2015-07-16

the problem is that the application contain a huge line of code and functions that add date to different tables, i just need a solution that avoiding me of changing the entire code, because i know the solution from the code part, but as was the application was working with no issues in the old server and now we have this issue in the new iis server, i thought that there are a solution to come on this problem without touching the code, my question is there any other setting i can do to IIS or window server to solve this issue?