There must be something in the water at sympatico.ca! This is the same isp
as John Marshall dwt(sic dimwit).
My post started out with "You have to be real careful using both expressions
dtSomeDate + 7 and
DateAdd("d", 7, dtSomeDate)." Both are adding an integer to the Date
function and my point was that one must understand what value results when
you add an integer to the Date function. No one can be as dimwitted as John
Marshall!!!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com www.pcdatasheet.com
If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
"Bob Quintal" <rq******@sympa tico.ca> wrote in message
news:Xn******** **************@ 207.35.177.135. ..
"PC Datasheet" <no****@nospam. spam> wrote in news:fGRff.526$ aA2.87
@newsread2.news .atl.earthlink. net:
Yes, and what do you think x and y were in my response ---
Adding a number to a date !!!!!
No! Your response was about determining if a number was between a
second number and third number. The fact that you used date numbers
as an example is irrelevant to the concept of determining whether a
number lies between other numbers.
--
Bob Quintal
PA is y I've altered my email address.