FO form data
I need same dates but when running following code in runnable class
select hRMRecruitingTable where hRMRecruitingTable.hrmRecruitingId == 'FA' && hRMRecruitingTable.kSPEndDateTime >= DateTimeUtil::applyTimeZoneOffset(hRMRecruitingTable.kSPEndDateTime, DateTimeUtil::getUserPreferredTimeZone()); info(strFmt("%1, %2" ,hRMRecruitingTable.kSPEndDateTime ,DateTimeUtil::applyTimeZoneOffset(hRMRecruitingTable.kSPEndDateTime, DateTimeUtil::getUserPreferredTimeZone())));
I got 2 different dates
Any solution?
I resolved the issue by using following techniques:
1:Functional
Set Time Zone
OMLegalEntities
SysUserSetup
2:Technical
utcdatetime currentDateTime = DateTimeUtil::getSystemDateTime(); select hRMRecruitingTable where hRMRecruitingTable.hrmRecruitingId == 'FA' && hRMRecruitingTable.kSPEndDateTime >= currentDateTime; info(strFmt("%1, %2" ,hRMRecruitingTable.kSPEndDateTime ,DateTimeUtil::applyTimeZoneOffset(hRMRecruitingTable.kSPEndDateTime, DateTimeUtil::getUserPreferredTimeZone())));
Set FormDateTimeControl property -> Timezone Preference: User
Hi Ashraf, In addition to Martin's response, you can check this thread as well. Martin has explained in detail
That's the expected behaviour. One value is in UTC and one in user preferred timezone. They'll be the same only if the current timezone offset of user preferred timezone is zero.
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156