I have a large amount of data in a MongoDB server that is very dependent on two dateTime fields. One of the analysts using MetaBase pointed out a piece of data expected wasn’t showing up in MetaBase but was when a Mongo query was run with same parameters.
I went down the rabbit hole with this one and noticed the issue was MetaBase is adjusting the time displayed vs the time in my database. Those two tables both display a time that is 4hrs (my timezone) earlier of the actual data in my db.
I tried setting the general timezone to UTC but that didn’t work. The two fields in MetaBase don’t have an option for any special data type either. I am using ISO8601 date formatting for my data in Mongo (“2014-12-28T23:00:00Z”), so I figured MetaBase would just display that?