MongoDB as sink connector not capturing data as expected - kafka?

If the built-in temporal conversions can help you it’s definitely the easiest and in that case better option. Happy to hear you got it working according to you requirements!