FileMaker: Get Previous Monday

This calculation will find the date range between today and whatever the previous Monday was. Best used as part of a navigation script that takes you to a set of recent/current records.

Get ( CurrentDate ) - Case (
DayOfWeek ( Get ( CurrentDate ) ) = "2" ; 0 ;
DayOfWeek ( Get ( CurrentDate ) ) = "3" ; 1 ;
DayOfWeek ( Get ( CurrentDate ) ) = "4" ; 2 ;
DayOfWeek ( Get ( CurrentDate ) ) = "5" ; 3 ;
DayOfWeek ( Get ( CurrentDate ) ) = "6" ; 4 ;
DayOfWeek ( Get ( CurrentDate ) ) = "7" ; 5 ;
DayOfWeek ( Get ( CurrentDate ) ) = "1" ; 6 ;
0 ) & "..." & Get ( CurrentDate )

Posting this here for future reference in case I needed it again.

Breaking radio silence

Auto-posted del.icio.us links are the new way to say “hello I’m here, but I’m busy at the moment.” Think of them as the blog equivalent of on-hold background music.

Anyway, I can’t be the first person to think that last night’s story of a potential attack (sorry, CYBERATTACK) on the financial networks is a trial balloon to obscure a legitimate market downturn. Guess that’s just par for the course these days.

SF book meme

The latest blog meme, this one courtesy of writer Ian McDonald

This is the Science Fiction Book Club’s list of the fifty most significant science fiction/fantasy novels published between 1953 and 2002. Bold the ones you’ve read, strike-out the ones you hated, italicize those you started but never finished and put an asterisk beside the ones you loved.

1. The Lord of the Rings, J.R.R. Tolkien
2. The Foundation Trilogy, Isaac Asimov*
3. Dune, Frank Herbert*
4. Stranger in a Strange Land, Robert A. Heinlein
5. A Wizard of Earthsea, Ursula K. Le Guin
6. Neuromancer, William Gibson*
7. Childhood’s End, Arthur C. Clarke
8. Do Androids Dream of Electric Sheep?, Philip K. Dick
9. The Mists of Avalon, Marion Zimmer Bradley
10. Fahrenheit 451, Ray Bradbury*
11. The Book of the New Sun, Gene Wolfe
12. A Canticle for Leibowitz, Walter M. Miller, Jr.
13. The Caves of Steel, Isaac Asimov
14. Children of the Atom, Wilmar Shiras
15. Cities in Flight, James Blish
16. The Colour of Magic, Terry Pratchett
17. Dangerous Visions, edited by Harlan Ellison
18. Deathbird Stories, Harlan Ellison
19. The Demolished Man, Alfred Bester
20. Dhalgren, Samuel R. Delany
21. Dragonflight, Anne McCaffrey
22. Ender’s Game, Orson Scott Card
23. The First Chronicles of Thomas Covenant the Unbeliever, Stephen R. Donaldson
24. The Forever War, Joe Haldeman*
25. Gateway, Frederik Pohl
26. Harry Potter and the Philosopher’s Stone, J.K. Rowling
27. The Hitchhiker’s Guide to the Galaxy, Douglas Adams*
28. I Am Legend, Richard Matheson*
29. Interview with the Vampire, Anne Rice
30. The Left Hand of Darkness, Ursula K. Le Guin
31. Little, Big, John Crowley*
32. Lord of Light, Roger Zelazny
33. The Man in the High Castle, Philip K. Dick*
34. Mission of Gravity, Hal Clement*
35. More Than Human, Theodore Sturgeon
36. The Rediscovery of Man, Cordwainer Smith
37. On the Beach, Nevil Shute*
38. Rendezvous with Rama, Arthur C. Clarke*
39. Ringworld, Larry Niven*
40. Rogue Moon, Algis Budrys
41. The Silmarillion, J.R.R. Tolkien
42. Slaughterhouse-5, Kurt Vonnegut
43. Snow Crash, Neal Stephenson*
44. Stand on Zanzibar, John Brunner*
45. The Stars My Destination, Alfred Bester
46. Starship Troopers, Robert A. Heinlein
47. Stormbringer, Michael Moorcock
48. The Sword of Shannara, Terry Brooks
49. Timescape, Gregory Benford
50. To Your Scattered Bodies Go, Philip Jose Farmer*

Not sure why the early cutoff date is 1953, there’s some significant work from before then. I also have to obviously question why Terry Brooks is on this list while Stanislaw Lem isn’t. And I’m not even going to snobbishly object to the inclusion of fantasy lit into a purported science fiction list (er, and Peter S. Beagle isn’t on this list because?)

I’ve been listening to StarShipSofa‘s podcast overviews of classic SF writers and I forget that I missed reading much of the early classics – no Blish, Budrys, Smith, etc.

R’lyeh Rising

newisland_maiken.jpgThe yacht Maiken encountered that new island that formed recently in the South Pacific and blogged about it. What I’m endlessly finding intriguing is just how much their photo series resembles every sci-fi “lost world” story ever. Distant travelers plow their way through an ultra-remote area. Weird stuff begins to appear in the water, whether it’s soil, strange plants, or an unusually warm current. The debris gets denser until suddenly you’re confronted with Skull Island or the Land That Time Forgot. I know, it’s good ole magma and volcanism, but if I was minding my own business out there and encountered the “stone sea” and an angry island I’d be wanting a crash refresher course in Welles, Verne, and Burroughs.

Geographers start your engines.

In other South Pacific news:

Oceanographers have discovered a broad, almost-bare patch of seafloor in the remote South Pacific. An unusual combination of circumstances has left the region without the mineral and organic sediments hundreds of meters deep that are typical elsewhere in the world’s oceans, the scientists say.

The sediment-poor region is about the size of the Mediterranean Sea and centered approximately 4,000 kilometers east of New Zealand. Researchers discovered the area, which they dubbed the South Pacific Bare Zone, during a cruise early last year, says David K. Rea, a marine geologist at the University of Michigan in Ann Arbor. The scientists were surprised when their seismic equipment indicated that there was no sediment in that region. A unique combination of factors seems to have dictated the area’s dearth of sediment that’s accumulated since the basalt crust below formed between 85 million and 34 million years ago, Rea and his colleagues report in the October Geology.

As Chris Perridas rightly notices, “The … Alert … was sighted April 12th in S. Latitude 34d21m , W Longitude 152d17m with one living and one dead man aboard.”

Get your elder signs ready.

OK, A New Size TV

CKB & Woz Ten years ago I was on a mailing list for PowerBook users. Steve Wozniak was on the list too and I noticed a very odd phrase in his .sig file: “OK, a new size TV.”

I got to wondering what the hell it meant and I didn’t want to email Woz directly because a) he’s busy and I didn’t want to bother him and b) I wanted to figure it out myself in case there was a chance of Valuable Prizes. My first thought was that the phrase was either a telephone alphanumeric or a line from a Tom Swift book – both of which figure prominently in Woz lore. The telephone number idea didn’t really work in a meaningful way and I got as far as one Swift book when one day I wondered if it was a transposition code. I wrote the letters out as OKANEWSIZETV and in a jump of mental sartori I realized that I could use the letters to spell STEVEWOZNIAK. Blame it on a healthy Scrabble appetite.

I emailed Woz and soon got a reply back congratulating me for finding the anagram. Last night at his talk/book signing at Book Soup, I mentioned the anagram story and asked him if his .sig file still has the phrase (it doesn’t). The Valuable Prize, of course, is getting a “you did well in figuring it out” congrats from Woz himself.

“Jack, you are WAY off script!”

palance_castro_mad130.jpgI can’t think of a single movie in which Jack Palance is anything other than great or completely bugfuck insane great. There’s a healthy helping of MST3K fodder in the years between Contempt and City Slickers, but I can’t think of anyone (maybe Donald Pleasence) who could take in otherwise crap movie and make it their own – not just chewing up the script, but the filmstock, the scenery, the extras, and anything else in site. Favorite insane Palance roles? Cocaine Cowboys (Palance as a rock band manager co-starring Andy Warhol as himself!), Che (Palance as Fidel Castro!), and two that did make it to MST3K: Angel’s Revenge & Outlaw. And of course as the eerie host of Ripley’s Believe It Or Not.

His IMDB bio entry is pretty amazing. Do they even make people like this anymore?

According to a website honoring movie celebrities that flew in B-24s, Palance burned his face severely while bailing out of a B-24 which was on fire during a training flight in Tucson in 1942 (that would probably have been the Davis-Monthan Army Air Corps base at that time) and after several surgeries was discharged in 1944. He is described as a “pilot in training”.

Speaks six languages: Ukrainian, Russian, Italian, Spanish, French and English.

Once fell asleep in his square during a taping of “The Hollywood Squares” (1966).

While an understudy to Marlon Brando in the Broadway production of “A Streetcar Named Desire,” Brando, who was into athletics, rigged up a punching bag in the theater’s boiler room and invited Jack to work out with him. One night, Jack threw a hard punch that missed the bag and landed square on Brando’s nose. The star had to be hospitalized and understudy Palance created his own big break by going on for Brando. Jack’s reviews as Stanley Kowalski helped get him a 20th Century-Fox contract.

Quote: “The only two things you can truly depend upon are gravity and greed.”

The obits all mention City Slickers and the Oscar speech, but if I had to pick one Palance role it would be the eccentric artist Rudi Cox in Bagdad Cafe who keeps trying to adequately paint the visions he sees in the desert. R.I.P.

The strangest story of the 2006 election

inverted_jenny.jpgSomeone in Florida used the most famous rare stamp in the world to mail in their absentee ballot. To add insult to injury, the envelope had no return address so the ballot couldn’t be counted and Florida election law requires that all ballots be sealed for 22 months.

FORT LAUDERDALE, Fla. — An absentee ballot was mailed with what may have been a rare stamp worth as much as $200,000 _ the famous Inverted Jenny _ but the envelope is in a box that by law can’t be opened.

Broward County Commissioner John Rodstrom discovered the stamp while reviewing absentee ballots. There was no name on the envelope, so the vote didn’t count.

What looked like a small stamp collection on one envelope caught Rodstrom’s eye about 8 p.m. Tuesday. At least one was from 1936, Rodstrom said. Then he noticed one had an upside-down World War I-era airplane _ the hallmark of an Inverted Jenny.

“I was a stamp collector when I was little,” Rodstrom told The Miami Herald. “I recognized it.”

Rodstrom discussed the stamp with other members of the canvassing board, and a stamp-collecting Broward County sheriff’s deputy overheard them talking about the possible Jenny.

He said the stamp would be very valuable if it was real. But it was too late.

“By that time we had already sealed the box. And once you seal the box, under the election law you can’t unseal it,” Broward County Court Judge Eric Beller said.

Ephemeral stuff that was worth more than a mere del.icio.us link

New Zealand is droning! And it’s not just the Dead C and those nutty Flying Nun guys, but a VLF buzz not to dissimilar from the Taos Hum that was bothering everyone years back.

Winston Moseley was denied parole early this year. I know I know, who cares. What made this story interesting was that forty-two years ago Moseley killed Kitty Genovese – still the go-to person for urban apathy horror. I had no idea the guy was still alive, it’s like flipping through the news pages and reading a current story about Bruno Hauptmann or Charles Starkweather. Digging around a bit, I see that Charles Sobhraj, Caril Fugate, the Onion Field killers, the Manson Family and Sirhan Sirhan are all still alive too.

Hmmm. I’ve got the makings of a 2007 dead pool list here where if someone on it dies I won’t feel bad at all. Also, predictably there’s a special section of the Kew Gardens history website devoted to Kitty Genovese.

Speaking of crime, Court TV has been on a roll lately and I’m happy that they’re running a new series of Masterminds. I was worried when the network was swallowed into the Turner empire with *sigh* an edict of “a broader program mix to bring in younger viewers,” but I’m looking forward to this counterpart to Oxygen’s awesome Snapped:

CourtTV’s planned new series each have something of a crime theme, including “Til Death Do Us Part,” an offbeat look at marriages that end when one spouse kills the other, hosted by filmmaker John Waters.

Lastly, like everyone else who read the Wired article on Darren Aronofsky’s The Fountain, I’m guardedly optimistic about it and hope that it does not suck. No matter how the movie turns out, I can’t wait to see the microzoom art of Chris & Peter Parks at full Arclight Cinema resolution.

Jason DiEmilio

1996. I had just started a record label/mail order house called No-Fi and I quickly needed some stuff to fill out the catalog as I was running out of unwanted CDs in my collection to sell off. There was a guy in Philadelphia named Jason who posted to the DroneOn list. He had a 7″ single label called Doorstep Vinyl and was discontinuing it to concentrate on his band The Azusa Plane and a new label called Colorful Clouds.

I sent him $50 bucks for a few things, but in return he sent me a GIANT BOX of singles, probably everything he had. I didn’t get a chance to thank him until a year or so later at Terrastock II in San Francisco. I babbled at him about how much I liked Azusa Plane’s set (“as loud and final as an asteroid strike!” or something) but he was frustrated and kept apologizing for the rushed set because the time was changed at the last minute and really, they were rushing so they wouldn’t miss Roy Montgomery. I don’t believe he made it out to the west coast after that. I think that last time I heard from him was in 2001 when I contacted him to get hold of The Highway’s Jammed With Broken Heroes which I think was his last release.

Last year, I was driving at night through a snowstorm in Oklahoma and a track from Tycho Magnetic Anomaly… came on shuffle play. I couldn’t think of a more appropriate, compelling, and well unnerving track to listen to then. I always wondered what he was up to.

Today this message showed up on DroneOn:

Subject: [DroneOn] woah – Jason/Azusa Plane dies
Date: November 1, 2006 12:59:46 PM PST
To: droneon@lists.quartzcity.net

Just heard on another list Jason DiEmilio of Azusa Plane died recently. He had some severe medical problems that, among other things, basically left him unable to listen to music so he ended his life.

In the later 90’s I listened to a lot of AP and played AP on my radio show. I was just looking at the chunk of split 7″ers in my singles boxes a few weeks ago. Didn’t he used to post here way back? Jason provided a soundtrack to many hours of my life. I hope he’s someplace where he can listen to tunes again.

How many times do people say “I wish we’d kept in touch” after tragedy? Way too goddamned much.

*sigh* R.I.P.