Acumatica如何计算LastDateTimeModified [英] How does Acumatica calculate LastDateTimeModified

问题描述

我最近注意到，从Acumatica检索LastDateTimeModified（通过WebService API）使我的日期和时间处于非常不同的时区-我猜是格林尼治标准时间。

I have recently noticed that retrieving the LastDateTimeModified (through the WebService API) from Acumatica gives me the date and time in a very different time zone - I am guessing GMT time.

但是，当我通过通用查询查看此内容时，似乎显示的是正确的时间-基于我在用户个人资料中设置的时区。

However when I view this through a Generic Inquiry it seems that it is showing the correct time - based on my Time Zone set up in the user profile.

从Web Service API检索时，是否有办法在正确的时区中获取LastDateTimeModified。我尝试为SDK用户更改时区，但没有成功

Is there a way to get the LastDateTimeModified in the correct time zone when retrieving from the Web Service API. I have attempted changing the Time Zone for the SDK user with no success

谢谢，
G

Thanks, G

推荐答案

对于大多数屏幕（除了少数CRM屏幕），LastDateTimeModified和CreatedDateTime存储在与数据库服务器计算机相同的时区中。使用Web服务读取它时，您是从数据库中检索原始值，而没有时区转换。

For most screens, except a few CRM screens, the LastDateTimeModified and CreatedDateTime are stored in the same time zone as the database server machine. When reading it using web services, you are retrieving the raw value form the database, with no timezone conversion. It is up to you to convert it to the desired timezone.

帮助->审核历史记录面板会手动转换为当前用户时区。我无法得到通用查询来显示您在问题中提到的时间；它只显示日期。

The Help->Audit History panel does a manual conversion to the current user time zone. I have not been able to get the generic inquiry to show the time as you mention in your question; it is only showing the date.

这篇关于Acumatica如何计算LastDateTimeModified的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！