Different date format in a data query

Thank you Elegault and AliGW =) (Not sure how to tag both of you)

Now I think I understand the situation. I didn't consider the , vs ; issue. I'll give it a new try and if my limited excel skills still come up short I'll do representative data insert.