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 PapoutsisOP
@Reply 3 years ago
Stamatios PapoutsisOP
@Reply 3 years ago
Kevin Robertson
@Reply 3 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 PapoutsisOP
@Reply 3 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 PapoutsisOP
@Reply 3 years ago
Stamatios PapoutsisOP
@Reply 3 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 PapoutsisOP
@Reply 3 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 11.
