Number of weeks passed

[Larry Linson]

The DateDiff function calculates a difference in weeks, but the result is
rounded. You may optionally set the first day of the week (default is
Sunday) and first week of the year. You'll have to use some other date
functions to check whether you need to increment the result to account for
days 1 - 3 of the week.

Larry Linson

 

[Van T. Dinh]

Newsgroups are like one big sandbox that all of us

UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

This includes people who post-date their questions!

--
HTH
Van T. Dinh
MVP (Access)



message news:[email protected]...

 

[Duncan Edment]

My apologies to all. I was testing the week calculations in my database,
and I have only just realised that I did not set it back to what it should
be.

Once again, my apologies.

Regards

Duncan

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

 

[Duncan Edment]

My apologies to all. I was testing the week calculations in my database,
and I have only just realised that I did not set it back to what it should
be.

Once again, my apologies.

PS Van, I would hardly class myself in the same league as a "sandbox peeer"!
It was, after all, a simple mistake. Given the question in the original
post, it should have been possible to identify this as a genuine mistake on
my part.

Regards

Duncan

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

 

[Van T. Dinh]

It may be a genuine mistake (and I noted that you previously posted with the
correct date / time) but I have been replying to post-dated messages so to
be fair, I don't pick & choose.

Another factor I should add is your sig. lines.

There's nothing to worry about with a genuine mistake...

 

[Duncan Edment]

Folks,

What's the quickest / cleanest way of calculating the number of weeks that
have elapsed between a static, hard-coded date, and the current system date?

For example, I want to work out the number of weeks that have elapsed
between 31st March 2003 and the current system date, always ensuring that
even if the current system date is a Monday, the current week gets counted.

Thanks & regards

Duncan

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

 

[Duncan Edment]

That's what I'm using at the moment Larry. Just thought there might be a
quicker way of doing it.

Duncan

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.