Date Time Defaults In Query Builder

(0) Share

Report

Posted on by Travis Bagley

395

Hoping someone can help me out with this. Client would like to filter several AR reports based on the created date time of the underlying records. What is throwing everyone off is that when you select a date using the date selector instead of inserting a range like 1/29/16 12:00 am .. 1/29/16 11:59 pm I get the below.

I have figured out that the time range is dependent on the users time zone (DST). In this case I am using EST GMT -5 and my ranges come in as 1/27/2016 07:00:00 pm .. 1/28/2016 06:59:59 pm. By changing the time zone to be GMT now I am at 12 to 11:59. This is very confusing for users and going to probably cause a lot of headaches as users will undoubtedly try to adjust the time.

Can anyone explain how to get this to show the correct 24 hour period? Is there a setting somewhere for this?

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

AX saves datatime values in UCT, so they represent the same time across globe. But AX form and report controls presents them to users in their corresponding local time zones, so they don't have to work with UTC directly. (I.e. two users in different time zones will see two different dates for the same UTC value in database.)

You're actually working with two different concepts. You defined the range in your local timezone (DST). Then if you look at the actual query sent to database, you obviously see a filter of UCT values, because that's what's in database. Using your local time when filtering UTC values would lead to a wrong result.

If you think that users would be confused, hide the query range from them. You can, for example, add date fields to the report contract and keep presenting them to users. Then generate the actual query against UTC values in background, never visible to end users.

Was this reply helpful? Yes No