Can't open mdb file

[Kristen]

@010hnoor

Personally I hate the inconsistency and would have preferred MS has NOT "fixed" this when DATE datatype was introduced.

---

NOOR

Were you trying to reply to my comment in another thread (which you appear to have quoted )

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

Needs to be "YYYYMMDD" (no punctuation) for DATETIME datatype. Its seems that "YYYY-MM-DD" is unambiguous for DATE datatype, but because it has always been ambiguous for DateTime we never use that format and stick to "YYYYMMDD" (ISO format "YYYY-MM-DDThh@mm:ss.sss" is also unambiguous, requires both the punctuation and the "T" separator; no other format is "safe" without an explicit conversion as SQL's parsing rules could interpret it in all sorts of different ways depending on Server Locale, U…