Avatar of AZZA-KHAMEES
AZZA-KHAMEES
Flag for Bahrain asked on

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
Microsoft IIS Web ServerASPWeb Servers

Avatar of undefined
Last Comment
AZZA-KHAMEES

8/22/2022 - Mon
SOLUTION
Ryan Chong

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
David Johnson, CD

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
AZZA-KHAMEES

ASKER
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
Ryan Chong

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

ASKER
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?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck