When exporting our data to an Excel xls or xlsx file, we have noticed that it the date field is adding a time based on our central timezone. When I look at the database to see if that time is in the field it isn’t showing nor is it showing in the card, but as soon as we open in Excel the time is there and the date is set for 6 hours earlier. Is there a way to set it for UTC time? The easiest example is if we enter a date for 12/30/2021 in the card when we export the data the date comes out as 12/29/2021 06:00PM which isn’t correct. Is there some kind of automatic calculation happening behind the scenes that is causing this to happen?
A little more information about my setup.
CMDBuild READY2USE READY2USE 2.2-3.4
Debian 4.19.208-1
Office365