Number of weeks passed

  • Thread starter Thread starter Larry Linson
  • Start date Start date
L

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
 
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.
Click to expand...

This includes people who post-date their questions!

--
HTH
Van T. Dinh
MVP (Access)



message news:[email protected]...
 
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.
 
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.
 
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...
 
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.
 
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.
 
Back
Top