When Today Is Used To Add Queue Item, But The Retrieved Data Via Get Queue Item Activity Is Not Correct

News Knowledge Base
1

Why Today() function in App returns incorrect value?

Issue Description: When use Today() to add queue item, but the retrieved data via Get Queue Item activity is not correct.

Resolution:

  • The Today() in Apps function returns the current date in UI, for example 07/04/2023 00:00:00 GMT+08:00 (China Standard Time).

  • But the datetime type data value is converted to UTC time before storing in database, the example data value in stored will be 07/03/2023 16:00:00.
  • Note that the Get Queue Item activity only retrieves the data from database, hence it will be 07/03/2023 16:00:00 instead of 07/04/2023 00:00:00.

  • Also, the /odata/QueueItems API has the same behavior.