Lesson 7: 10:30 I think there is a mistake with the FDONM (First Date of Next Month) field. FDONM: DateSerial(Year(Date()), Month(Date())+1,1) wouldnt work if Date() is on December. Lets say Date() is December 15, 2022. FDONM would return January 1, 2022 instead of January 1, 2023.
Lesson 7: 12:34 Lets say a customer has a birthday on January 8, 2023. IsBDnm (Is Birthday Next Month) field wouldnt correctly detect that the customer has a birthday next month since the year of FDONM is 2022 instead of 2023.
Kevin Robertson
@Reply 4 years ago
I just tested it with the dates you stated and it works fine.
Kevin Robertson
@Reply 4 years ago
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
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 Expert 28.