I do an excel export of some data from database.
Date value in database: 2017-02-15 15:31:54 (timestamp)
I set format of excel field like this:
setFormat('dd.mm.yyyy hh:mm:ss')
But the value i get in my excel sheet is 16.02.2017 14:31:54.
Do you have any idea why this happens?
Edit:
If I echo the value of the variable which I insert to excel field, the output is correct. But in excel then there is the wrong value.