[BUG] - Cannot convert from BSON type string to Date

[MANDLA15]

Environment

• DocumentDB JDBC driver version: 1.4.4
• DocumentDB server version: 4.0
• OS: Windows 10 64-bit
• BI Tool or client name: Tableau Desktop
• BI Tool or client version: 2022.1
• Java version (if known): 8.341

---

Problem Description

1. Steps to reproduce: key field on DocumentDB is Date. However on Tableau appears as string and unable to convert.
2. Expected behaviour: display date on rows field
3. Actual behaviour: error executing query
4. Error message/stack trace:
   "Error Code: A96BDB88
   Execute query has failed, error: shadow.com.mongodb.MongoCommandException: Command failed with error 16006: 'can't convert from BSON type string to Date' on server documentdb. The full response is {"ok": 0.0, "operationTime": {"$timestamp": {"t": 1692798039, "i": 1}}, "code": 16006, "errmsg": "can't convert from BSON type string to Date"}."

[narek]

Hi @MANDLA15 Thanks for reporting a bug. I'll have a look at it.

[narek]

Hi @MANDLA15 $convert is not supported in DocumentDB yet. We'll update our release notes, once we add a support for $convert operator.