- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
A lot of us here in The Internet have been really worried that your spelling and grammar were not up to snuff, and that your internal documentation of this issue might not be as meticulous as we'd hoped. Thank you for putting our minds at ease.
Admin
I cam across a similar issue in our systems about 2 months ago.
Someone noticed that the production planner report stopped showing any 30day+ orders towards the end of last year. As we hit December, all orders due under 30 days started to vanish.
As I dug into the five year old stored procedures behind the report, I found that the system used a reserved date of 25th dec 2010 for special orders. However that wasn't the best part. The production planner had a clause to ignore these special orders:
WHERE order_date <> 2010
Admin
Admin
Hmmm... I see you didn't account for the 14th period. Just wait till that one bites you.
Admin
Agreed. That's why, here in the USA, the period goes inside the quotation marks. Sigh.
(There are, admittedly, a handful of us continuing to act as freedom fighters on this front. However, I'm holed up, and it's only a matter of time before they realize I'm outta guns.)
Admin
FTFY
Admin
FAIL! Your source code is readable.
Admin
I can't help but wonder if this piece of code was not written in, say, 1990, and the programmer said to himself, "Let's pick a date way far in the future, like, oh, say 2010."
We had a similar problem here: We have date ranges on sales tax rates, so when rates change, we can tell the system to use the old rate until such-and-such a date and then switch to the new rate. When they were entering all the tax rates that had no specific expiration date, somebody decided to put a far future date in: Jan 1, 2010. Guess what happened a month ago.
Admin
It's not that at all. People in the past hated numbers that are divisible by 67.
Admin
That's because it wasn't far enough. They should have used Dec 22, 2012. It's a valid Gregorian date, but the History Channel tells me that there's absolutely no way that you would have to process orders on it.