[AccessD] Figuring the date

Hi Max

Oh, it may interest you that even though I live in the country, the famous town Elsinore is only 6 km away. This housed a local brewery, Wiibroe, which for years ago was bought by another "local" brand you may have heard of, Carlsberg. Sad thing was, that the wise marketing guys figured out that the famous "Wiibroe Imperial Stout":

http://www.ratebeer.com/beer/wiibroe-porter-imperial-stout/7789/

was to be ceased in favour of Carlsberg's own imperial stout:

http://www.ratebeer.com/beer/carlsberg-carls-porter-40gammel-carlsberg-porter-imperial-stout/6974/12252/

Not a bad beer but still ... how popular do you think Carlsberg was at that time?

Two years ago, however, the production of the Wiibroe Imperial Stout was reestablished in the old buildings of Wiibroe at the highest standards. This meant that the latest to brews were abandoned for some reason and now the shelves at the stores are ripped. I still keep _one_ bottle from the autumn just in case, while local beer enthusiasts are walking in circles. Should they come too close, I have arranged for a dark place to hide the bottle!

/gustav


>>> max.wanadoo at gmail.com 07-03-2009 20:46 >>>
Gustav, If you walk down the road and see a guy with a smile on his face
coming towards you - that will be me!

I *try* my best to keep humour as an essential part of my Super-Ego, viz:
http://en.wikipedia.org/wiki/Ego#Ego 

The Super-ego works in contradiction to the id. The Super-ego strives to act
in a socially appropriate manner, whereas the id just wants instant
self-gratification. The Super-ego controls our sense of right and wrong and
guilt. It helps us fit into society by getting us to act in socially
acceptable ways.

Pub life keeps me "In Society", otherwise I would be quite happy to sit in
front of my laptop for hours.  I am by nature a gregarious person and a bit
of an extravert and enjoy other people's personalities.  I *love* happy
people.  I strive to retain the child in me and refuse to grow old. I do not
want to grow old gracefully - my body may age, but I will hang on to fun and
love and humour for as  long as I can.

Thinking of which, time I went to the pub!  There's a pint sitting somewhere
with my name on it. Ha!

Max
Ps. I just want code that is 100% accurate 100% of the time.  Is that asking
toooo much??? <g>


-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 07 March 2009 19:12
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Figuring the date

Hi Max

Hanging around for too long at the pub??

Drew explained how it works and I added a little. Should be possible to
browse and collect?
And Drew's code is a one-liner. Eh ... cut and paste one line?? 
Be careful with the strong beers .. should I mention (serious shutter and
tremble) non-alcoholic beers??

But be aware. That code is not for European use. We mostly use the ISO
8601:1988 standard for weeknumbers (week 1 is first week with four days).

/gustav 


>>> max.wanadoo at gmail.com 07-03-2009 19:54 >>>
So, what is the final code that I can put into my Tools Box?
And, could somebody put a line of comment in to say exactly what the
function does and what params are expected.

Thanks guys.

Max