Results 1 to 3 of 3

Thread: Date Posting Issue

  1. #1
    Join Date
    May 2010
    Posts
    3

    Date Posting Issue

    I am using an SQL 2005 database with a web-based front end written by another party. I have been having issues with the date format for months and the software provider seems to be at a loss. Basically, the display of the month and day flip (mm/dd/yy becomes dd/mm/yy). The software is an accounting package and the date issue causes major tumoil (a transaction posted May 8 becomes Aug 5 and if you try to post May 13 you'll get an error - date out of range). Each time this happens, I have to go into my web-server and restart IIS and the issue resolves itself (temporarily). I have domain admin. priveleges and interestingly, if someone else goes into the webserver with local admin. priveleges and and resets IIS, the problem is not resolved. I realize that this may be an IIS issue more than a SQL issue but I've been working on the IIS angle for months without success. A reboot of the web server will often trigger this issue but it also happens frequently without a reboot. The date format preferences on both the web-server and database server (both running Windows Server 2003) are set identically so I don't think that this is causing the issue. Thanks

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Sounds frontend app uses different date format than sql2k5's default format, may need change default os date format on sql server.

  3. #3
    Join Date
    May 2010
    Posts
    3
    I checked the documentation and the vendor shows a regional setting of English(US) and mine is set to English(Canada). I've switched it and we'll see if that does the trick. Thanks for your help.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •