In lesson 3, the example Like "*/2012" didn't work for me at 1st.
Later found out my date is formatted "dd/mm/yyyy" in CustomerT, but in my PC setting is "dd-mmm-yyyy" (24-Mar-2012). So I should use the criteria as: Like "*-2012".
Just leave the comment here for those who facing same problem.
Kevin Robertson
@Reply 4 years ago
Yeah, I recently switched to the ISO Date Format so using the example from the video my criteria would now be Like "2012-*".
Qi Jian NeoOP
@Reply 4 years ago
After watching the ISO Date Format video, now I switched almost all my work & personal date format into ISO Date Format 😎
Yeah, I did too... problem is the VBA editor still forces you to use mm/dd/yyyy, so if you enter dates in VBA code as #2022-01-20# it switches it to #1/20/2022#. Not very helpful, Microsoft.
Scott Axton
@Reply 4 years ago
Very useful tip - thanks for letting us know. It may help me to help others in the future.
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 Beginner 5.
