It sounds like the Order Manager may be getting your dates in the wrong format. Please give us a call so we can run some checks on your system. Also - I have added code to that warning message to display both dates in long format that makes it clearer which date is the problem.
Barney Stone, President Stone Edge Technologies, Inc. 215-641-1837
I got this issue also - i started to pull my hair out for a while as i was getting orders with the months and days in the US format in order manager when i require UK date settings - bizarrly in the order manager this was sometimes flip flopping too so after a certain date the day and month were in the UK (correct for me) format (without any changes being applied)- this also cropped up in all reports and packing/invoices as the data is pulled from source - im using an oscommerce based (cre loaded) store and all settings in osc were definately correct.
So if you are getting order placed today 1st Feb 2007 as 2nd Jan 2007 (in short date format i.e. 1/2/07 as 2/1/07) i found the solution for creloaded oscommerce stores and suggest similar may be occuring for other stores (please back up all your store/data and stoneedge database before any changes or ask stoneedge first)
This is what i did but ask stoneedge if you are not sure.
in loaded-import.php (your import script) file there are 2 sql queries which force the date format to US standard find these and change the day and month parameters around - i think there are only 2 sql queries you need to change (6 date formats altogether in loaded-import.php).
If you are not a programmer or dont feel comfortable playing around with your files please ask StoneEdge Team first.
This is for anyone who uses DD/MM/YY as date standard
the sooner you fall behind the more time you have to catch up
FYI, this is fixed in the latest script releases for osCommerce. You can customize the date string used, but the default formatting makes dates in the form of "2 Jan 2007 12:34:56", which should parse correctly regardless of date format used by Windows (and by extension, Access).
Date bug?
Posted - 09/19/2005 : 07:43:55 AM
