Week Numbers
Something funny happened today. I needed a formula to reliably work out the number of the week for any given date. So I searched the LDD forum for "week number" and opened the first result as it looked promising. Then I decided to read the main post that it was a response to. It took me a while to notice that it was me who posted it in the first place. Even more freaky is the date it was posted. Three years on and still no idea how to reliably work out the week number! In the end I opted for a sunday-to-sunday date string in the format 1901203_26012003, using the following formula:
DateWeekStart:=@Adjust(@Now; 0; 0; 1-@Weekday(@Now); 0; 0; 0);
DateWeekEnd:=@Adjust(DateWeekStart; 0; 0; 7; 0; 0; 0);
@ReplaceSubstring(@Text(DateWeekStart) + "_" + @Text(DateWeekEnd);"/"; "")
Thanks to Rob Wunderlich for treating me to a DVD of the Third Rock From the Sun. My favourite American comedy. Well, the only one I like really. Am I the only person in the world that thinks Friends is awful?
I wish I could make it to LotusSphere to thank people face-to-face and even just to put some faces to some names. The trouble with being a penny-pinching scumbag contractor is that it's just not economically attractive. Not only would I have to pay my own way there and in, I would be missing the wages from time off work! Maybe next year, if I'm not working, I'll make it over. Got some relatives in Florida somehere I could probably stay with. Jacksonville I think.
Ed Brill has acknowledged us doubters.
Skip to the 
You can subscribe to an individual
Yes Jake,
Friends indeed has gotten bad. A good yank comedy show is called Scrubs, its hilarious.
Scrubs is very good, its currently on Thursday nights at 10pm on Sky 1.
Friends is indeed a bit lame now. I still like Frasier though..
Well, I AM CANADIAN (local joke regarding a beer brand: Yes we have a beer that's called Canadian!!!) and I just love That 70s show ({Link}) It is quite good and you shoudl like it if you like 3rd rock.
I thing you guys still have in Europe (at least had 3 years ago when I was in Belgium) is the Muppet Show. I miss it so much...
Different matter: Jake, did you get a chance to look at what I sent you? I can still give a hand for the Notes interface if you want. Just give me some feedback.
Regarding the announcement of iNotes/ Netscape 7 compatibility... This is a bit of a strange announcement... An (award winning) web based application that is going to be compatible with Netscape 7 ?! Is not this what it should be in the first place to be called a web based application ?...
I dont watch sitcoms... for my fun fix I go to the IBM/Lotus sites instead.
If you're looking for ISO week numbers, you could check out {Link}
In line with the wish list one might wish that the calendar views (they have week numbers don't they?) were more open to programming...
Friends is awful.
"Penny-pinching scumbag contractors" aren't the only ones who have trouble getting to LotusSphere -- try explaining to your Canadian boss that you absolutely must get to Disney World -- or anywhere else in Florida -- for vital business purposes in mid-winter. It's not as easy as it seems....
@WeekNumber will be available in R7...
You're right about Friends, its been crap since the end of series 3
Seinfeld is my all-time favourite US comedy series though. Luckily one of the local channels here (Channel Ten - Oz) regularly repeats episodes every week night.
I just got the whole of 'The Office' first series and that was great. What do you think?
Jake,
I calculate te week number according to the ISO8601 standars. This standard defines the week number by:
- weeks start on a monday
- week 1 of a given year is the one that includes the first Thursday of that year.
(Ed: Here it is.)
Hmm - horizontal scroll!
Friends: Overated, irritating, naff
Scrubs: Refreshing, original, funny
3rd rock: Perceptive, but increasingly tired
I've been brief for once. I don't like it.
Enough of the Friends-bashing! It may be a little inane but at least it is harmless.
It is certainly better than much of the tat we throw out. "My Hero" anyone?
For all round good comedy you need look no further than "The Day Today". This is me, Condublasney Piper, bidding you good-night.
Talking of re-visitng your own posts...
I did a very similar thing, looked up "OLE and excel 2000" on LDD, and read all these ultimately useful posts, turns out the poster was my collegue sat 3 feet away!
I had a similar experience which involved enlisting some support from a third party.
When they came back with a URL for a solution, whose post was it? The customer's!
Jake:
Happy to send along the DVDs, and happy to have given you a chance to start a new Blog War over American sitcoms.
As much as I hate to admit it, I don't believe I've ever actually seen an entire episode of Friends, and 3rd Rock only seemed to catch my attention in reruns.
Regardless, enjoy!
- Rob