-
data format of msdyn_date should be "YYYY/MM/DD H:00:00" regardless of the way to be created
There is 2 ways that timeentries record is created. Data format of msdyn_date varies depending on the way. 1. from "import" button: "YYYY/MM/DD X:00:00" *X is variable depending on users' timezone. 2. from "+New" button: "YYYY/MM/DD" This difference causes big problems. When time entries are exported to Excel, date of msdyn_date field changes in some cases For example, if timeentries record (msdyn_date: 2021/08/20) created by User A (timezone: GMT+ 08:00) form "+New" button is exported to Excel by User B (timezone: GMT+ 00:00), msdyn_date is 2021/08/19 16:00:00 in Excel Data format of msdyn_date should be "YYYY/MM/DD X:00:00" regardless of the way to be created