weeknubers(odd or even)

willem

07-31-2001, 06:57 AM

Is there a function that retrieves the weeknumber, can i see whether it is odd or even.

That's all

willem

thank you

Thinker

07-31-2001, 07:07 AM

You can use DatePart("ww",MyDate)

I think therefore I am... sometimes right. images/icons/wink.gif

BillSoo

07-31-2001, 05:34 PM

....and to see if any integer is ODD, you can simple use the AND operator with 1.

eg.

7 AND 1 is 1 (true)
8 AND 1 is 0 (false)

"I have a plan so cunning you could put a tail on it and call it a weasel!" - Edmund Blackadder

Thinker

07-31-2001, 05:39 PM

That's a neat trick, BillSoo. I have to remember that one. I would have used mod 1 but I'll bet the And is faster.

I think therefore I am... sometimes right. images/icons/wink.gif

BillSoo

07-31-2001, 05:53 PM

....I think you meant MOD 2 instead of MOD 1....

but yeah, I seem to recall testing it one time and AND was a bit faster...of course, that was back in VB3 days so they may have improved the MOD function since then....

"I have a plan so cunning you could put a tail on it and call it a weasel!" - Edmund Blackadder

Thinker

07-31-2001, 05:58 PM

Yes, mod 2 images/icons/blush.gif

Been one of those days.

I think therefore I am... sometimes right. images/icons/wink.gif