I'm using Magento 2. So, I created a Adminhtml data grid in a custom module. The problem is that the data grid doesn't match the exported data. I've set the timezone, but it seems data grid and exported data use different time base.
Below is the code I use to show created_at attribute.
<column name="created_at" class="Magento\Ui\Component\Listing\Columns\Date" component="Magento_Ui/js/grid/columns/date"> <settings> <filter>dateRange</filter> <dataType>date</dataType> <label translate="true">Created At</label> <sorting>asc</sorting> </settings> </column>
Tell me if you need more information regarding this problem. Any hint is appreciated. Thanks!