05 Last Customer Contact - Microsoft Access Expert 11


	Back to Access Expert 11 Comments List

Upload Images Link Email

05 Last Customer Contact

Stamatios Papoutsis

2 years ago

Dear Richard,

Mine as well as your Database cannot DLookup the DateTime based on the MaxOfDateTime from ContactT table. Both return Error which is related to the Date syntax. Is it because I have a different setting of the Date which is yyyy/mm/dd ?

Best regards,

Stamatis Papoutsis
Greece

	Stamatios Papoutsis OP 2 years ago

	Stamatios Papoutsis OP 2 years ago

	Kevin Robertson 2 years ago
I'm thinking it may be the characters to the right of the Date/Time which I'm assuming is AM/PM in your language. Try using a different format to see if that solves the issue.

	Stamatios Papoutsis OP 2 years ago
Dear Kevin, You were right! I changed the selected language to English and the problem was solved! Thank you! Best regards, Stamatis Papoutsis Greece

	Stamatios Papoutsis OP 2 years ago

	Stamatios Papoutsis OP 2 years ago
In order to be more specific, I kept my Country or Region as GREECE but I changed the Regional Format from Greece(Greece) to English(United States) so the Greek characters μμ were replaced with the Latin Characters pm and so on. Thanks again!

	Stamatios Papoutsis OP 2 years ago

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