Posted: 21 Dec 2018 8:28 EST Last activity: 4 Jan 2019 7:24 EST
Problem when saving property as datetime on database
We this situation in here. We have a section with initial date and final date, and because it is a date control and the database class is datetime, we need to save as datetime. We force the dates to be like that:
On clipboard the values it is exactly how we need, but when we do obj-save, then on tracer we noticed that after the obj-save it is called a "merge" which have the sql it is called, and there the dates got a change for minus 2 hours, and when we look at the data base the dates are wrong with minus 2 hours. I want to save this enforced time regardless timezone, I want to be always the initial date at zero and final date at 23:59:59. Can somebody help with that?
Thanks in advance
***Edited by Moderator: Pallavi to update platform capability tags***