- 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
Tell me, if you really are Indian, how about answering some of these linguistic French questions?
Admin
Ah, VB(A) fun with internationalization...
On French systems, CStr(True) is not "True" either, but "Vrai", which can given nice results when storing settings into ini files (SaveSetting) and trying to parse the INI files on an English machine. SaveSetting will happily convert the Boolean to String and back, but CDbl() fails with error 13 if it suddenly finds a string it cannot parse.
And I know I wrote an application a long time ago that intentionally changed the system date by setting Date$ to a new value. (As a workaround, one could also deny the current user the right to change the system date, which would also make the assignment fail).
Admin
Admin
Admittedly, it is easy to confuse with a certain function that returns the system date, since it is also named Date.
How can you tell the difference? Because you can't assign to a function.
Admin
Anyone who abuses the system clock in this manner should be shot. Not in the head - center mass. The head would just be an air pocket in this instance.
Admin
Admin
The most logical date format to a computer is ISO Date, YYYY-MM-DD or 2011-07-05 today. This sorts correctly from largest scale to smallest.
English is a Germanic language that places adjectives before nouns. In a similar manner, "July 5th, 2011" has "July" before the day it describes.
The real WTF is how people don't understand that people speak different languages. Don't assume that any other country follows the same dates or numbers you do.
Admin
hawt
Admin
The correct term, of course, is "USonian.
Admin
Really? I thought it was pronounced "'merican, from the you ess ov ey"
ducks
Admin
The international standard is YYYY-MM-DD. Among other advantages, it sorts correctly.
Admin
The portuguese do.
Number - Portuguese - Literal translation 1999 - Mil novecentos e noventa e nove - Thousand ninehundred and ninety and nine; 2001 - Dois mil e um - Two thousand and one; 2159 - Dois mil cento e cinquenta e nove - Two thousand hundred and fifty and nine;
But this is mainly a cultural thing. In the 1900's we used to shorten the year by saying only the last two numbers, but after 2000 we say the full year.
Admin
Admin
Aside from VBA insanity, someone needs a good slap about the head for not realising that you don't have to store dates in the same format as you display them in. Le sigh.
Admin
YYYY-MM-DD. Learn it. Live it. It is the One True Date Format. Thou shalt have no other date formats before me.
And yeah, it was pretty damned obvious that the problem was the US/FR format difference. Should have taken no more than 2 minutes for the devs to reproduce it. Then again I suppose I shouldn't be too surprised. These are VBA devs we're talking about.
Admin
This whole thing could be prevented with a login script utility that would delete all VBA code from a machine.
Admin
TRWTF are numerical dates. The world should settle on commonly used month names and abbrivations. As we surely can not agree on a new spelling for the old month names, new world-wide known names for months need to be used, like McDonalds, Porsche or Beatles.
Written on the 5th of Porsche, 2011.
Admin
Ahhh. Thanks you very much Mr. Alex Papadimoulis!!! This is the exact codes I am needful. However, I have much doubt in the VBs, can you possibly post this using Java 1.6 runtime. Using of Scala language is acceptable because I have recently increased my skills in this. Also, as always, I have requirements for JUnit testing.
Admin
Admin
I congratulate and feel bad for you at the same time for having enough exposure to VBA that the first thought you had was the 'Date =' "feature". And honestly, until VBA docs were mentioned explicitly, I assumed it was SSRS or equiv. simply due to the level of doubt the developer had that it was being caused by the report.
My bad for thinking the dev knew what the hell he was talking about.
Admin
In reality, the adoption of languages and standards would be market driven. Americans don't adopt the standards of other countries because they don't have to. Individual European countries couldn't get very far without fitting in, so they adopt each other's standards in order to prosper.
Admin
The moral of the story is that TRWTF is France, right? No? Drats.
Admin
The important message from this lesson is that governments are universally redundant. Their only use is to give bossy pricks something to do to make them feel important.
Admin
Except it doesn't. Unless you're referring to the Set Date/Time control panel shortcut in XP, which was replaced in Vista with a calendar display.
TRWTF is that a developer didn't spot the localisation issue immeadiately and check the VBA docs to see how they'd set the system date. From there diagnosing and fixing the fault should take 5 mins, not three years.
Admin
Admin
Admin
As a guess it went:
"Here's your progra-yum, boys."
"Putain de merde! La programme ne fonctionne pas!"
"Ah yeah, looks li-yuk you gotta be admin to run thay-at report."
"Mais pourquoi? Cela n'est pas sans risque!"
"Yeah, but hey-ull, Bubba's gawn an' fall'n asleep again, y'all ..."
(Gallic shrug, mutter under breath: "Scheisskopf ...")
Admin
But to recap: he's saying Belgium can't regulate anything, and you're countering by saying that they're just lost in the sauce because of months of pointless negotiations just to form a government, but soon they'll gear up to start producing unbelievable quantities of red tape.
Is there a point to this? I mean, will you ever have enough regulation, enough laws and enough welfare?
Admin
Close, it's "merkin". (GIYF btw)
Admin
Here are a few examples: http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4GGHP_enUS433US433&q=%22july+4th+holiday%22
Admin
My goal is to turn it into a highly-abstract class library with lambda expressions and iterators all over the place. That should frighten off anyone like the person who wrote the goddamn thing in the first place.
Admin
Religion became redundant the moment the police force was invented.
Admin
Admin
Nope. It's: "Twen-ny-lev-ven".
Admin
Admin
Throw in a coupla' Funcs and some events, and they'll swear it's the work of the devil. (not saying that your not evil though)
Admin
What? I looked up merkin and found that it used to be a wig worn by prositutes after shaving their genitalia.
Ah, I see what you did there...
Admin
We need a 'like' option for posts... or in this particular case: a 'ftw!' option...
Admin
Admin
Argh. I meant to quote "Yup. Just like that grand American holiday, "July the 4th," that we just saw... ".
Admin
As a Brit in the US one 4th of July, I was asked by a native how we celebrate 4th of July in Britain.
Admin
Admin
FTFY
Admin
You have a point there. Months are pretty worthless as units (arbitrary, inconsistent...), and there's no real reason to have them to begin with. Why not just have a 365-day year, and do billing cycles by 4 weeks?
Admin
How do you explain this then?
http://www.ny1.com/content/top_stories/142094/many-new-yorkers-beach-bound-this-holiday-weekend
Damn...wrong link and can't delete. Ignore this for now. Sorry.
Admin
Ha! Your meager OTDF still falls prey to the dreaded threats of Leap Seconds, Time Zones, Daylight Saving Time! (that's "Summer Time" for our friends across the pond)
There is only One True Date Format and that is (x, y), where x is the number of weeks since January 6, 1980; and y is the millisecond offset into that week starting from midnight (UTC, not including leap seconds since January 6, 1980).
Admin
Ahhhh...yes! The old application destroys operating system problem class. Brings back memories.
On the HP/3000 line of computers, back when MPE III was the proprietary operating system, we had what were called "system failures". These occurred, usually, when the operating system discovered it had "immolated itself", such as by trying to deadlock itself; or by corrupting a critical system table; or by terminating its own memory manager; and etc.
We had a BASIC interpreter on this system that had a list command used to list source lines. If you tried to list lines that didn't exist, you would get something like this:
Repeat your erroneous command 4 times in a row (yeah, why would you, but users are called "lusers" for a reason) and the result would be a System Failure.
Why? No idea. HP fixed the problem in the next version of the O/S, without providing any insight.
But (as you might imagine) it's kind of...undesirable...to have the lusers on a time-sharing system be able to bring a whole system down by typing an erroneous user-application command 4 times in a row.
Admin
And the biggest benefit is that it's human readable.
Admin
No, the real WTF is functions that outlive their usefulness. Setting the date from Microsoft Basic (yeah, about 99 versions ago) was useful on the IBM PC, or even the IBM PC AT.
It is more hazardous than useful these days. Yet it survives: An obsolete function looking for a place to happen.
Admin
In Danish, we count ....eighteen, nineteen, twenty, one-and-twenty, two-and-twenty, three-and-twenty etc. So we're using "middle endian" with numbers: "one thousand nine hundred four and eighty" (but "nineteen hundred four and eighty" when talking about calendar dates).
And the names for 10^n, where n is an integer and 5<=n<=9, are actually named after the number's multiplum of 20. So 50 is actually "half-third-times-twenty" and 80 is "four-times-twenty".
Not that any of you care.
At least it's better than the old British monetary system where you had to do Mod(x, 12) constantly.... :-)