I think there is a mistake in the example Lesson 2 13:30 In the "customer since" field, if we want to see people who have been customers for about a month, the criteria is supposed to be >date()-30 and not <date-30 because <date-30 would have listed customers who have started decades ago like since 1/1/1995
Scott Axton
@Reply 4 years ago
I had to go back and listen again. You are absolutely correct.
GREAT catch! I can't believe that this wasn't called out before in almost 10 years.
At about 13:10 Richard says "Let's say, for example, you want to see all the customers who became customers before today's date". That would be < Date() .
Then "for about a month" would indeed have changed it to > Date()-30
(Technically that would also show some one who has only been a customer for a day. ) The idea is that he was showing how you could use regular math with a date.
Richard you have a winner here! I sure didn't pick it up over 5 years ago.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 5.
