Finance | Project Operations, Human Resources, ...

utcDateTime issue

(0) Share

Report

Posted on by Ashraf_ahk

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?

All responses (3)

Answers (0)

Sort by

Suggested answer

Martin Dráb 241,511 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.
Mohit Rampal 12,573 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Ashraf, In addition to Martin's response, you can check this thread as well. Martin has explained in detail

community.dynamics.com/.../utcdatetime-and-timezone-offsets
Ashraf_ahk 75 on at

Like (1)

Report
Copy link

Link copied!
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