mario.mesquita Member since 2013 8 posts
B.Braun group
Posted: 1 year ago
Last activity: 1 year 9 months ago

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:

myPage.initialDate = @concat(@whatComesBeforeFirst(param.initialDate,'T'),"T000000.000 GMT -3")

myPage.finalDate = @concat(@whatComesBeforeFirst(param.finalDate,'T'),"T235959.000 GMT -3")

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***

Low-Code App Development Dev/Designer Studio Data Integration Java and Activities Data Integration
Moderation Team has archived post
Share this page LinkedIn