Like Date Use PC Formatting - Microsoft Access Beginner 5


	Back to Access Beginner 5 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Like Date Use PC Formatting

Qi Jian Neo

4 years ago

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 Neo OP @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 😎

	Richard Rost @Reply 4 years ago
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.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 5.

Next Unseen

New Feature: Comment Live View