Microsoft Access Beginner 5

Access Beginner 5

Mistake in Date Example Upload Images Link
Hendra Gunawan
11 months ago

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
11 months 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.

Richard Rost
10 months ago

Yeah... uh... that was a test... and... uh... you're the only student who passed. :)

I'll definitely put a note on the page. Good catch. You get a gold star.

Dan Jackson
5 months ago

You need a badge for when people point out your mistakes. Like a uni hat or something!

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Beginner 5 Comments

Subscribe to Access Beginner 5
Get notifications when this page is updated