DateDiff - firstdayofweek argument

[Aziz]

In online help under MS Access 2000, it says for the
DateDiff function that if we use the "w" interval symbol,
the result can be affected if the firstdayofweek value is
used. Can anyone give me an example of this?

Regards

Aziz

 

[Bryan Reich [MSFT]]

It doesn't affect the "w" interval symbol it appears (at least not in any of
the tests I ran), but it does affect the "ww" interval symbol.
I have written an email to the people who manage the online help content and
pointed this apparent issue out. Hopefully they will be able to give me a
scenario where it matters, or if it doesn't matter hopefully they will fix
the documentation.

 

[Aziz]

As I thought. Thanks.

-----Original Message-----
It doesn't affect the "w" interval symbol it appears (at least not in any of
the tests I ran), but it does affect the "ww" interval symbol.
I have written an email to the people who manage the online help content and
pointed this apparent issue out. Hopefully they will be able to give me a
scenario where it matters, or if it doesn't matter hopefully they will fix
the documentation.
--
Bryan
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm





.