2,016
greeting everyone
i'm really confused from time in POS retail tables
for example when i checked on field CreatedDateTime in table it's not match with real time for transaction
but POS make it that match as real time
is there any hidden calculate for that?
here example for issue which i'm faced
i have time transaction show me in POS 3:09:46 PM
but in field CreatedDateTime of that transaction table 12:09:46 PM
and here pic explain my example
POS TIME
DATABASE TIME
Hi
Time difference is due to different time zones used by SQL Database and AX Client.
As SQL database is using UTC and Ax client uses the current timezone of the client.
Hi Mohammed,
AX utilizes the utcDateTime data type to store date time information in the database using the Greenwich Mean Time definition of time.
Whenever displayed on forms and bound to table fields, the data is converted to the user's preferred timezone.
You can use DateTimeUtil::getSystemDateTime() method. This returns the current system dateTime as a type of utcDateTime, and there is no timezone offset applied to the data.
Hope this helps.
any idea about that?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (