Dear Richard, I think there is a logical mistake in the Is date in this year to date function you present in the lesson 01 at 7:05. The formula you give is Year(D) = Year(Date()) and Month(D) <= Month(Date()) and Day(D) <= Day(Date()). I am writing this on DATE() = 2023-05-16. If you apply your formula to the day D = 2023-04-18, the result would be false due the day in April being a bigger number than the day in May (18>16). This is not the result you intended to get (explanation at 7:28).
Kind regards, Jeff
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.