Share
ReportHello,
Are there any triggers or cause where modified date is earlier than the created date time?
You’re offline. This is a read only version of the page.
10
Hello,
Are there any triggers or cause where modified date is earlier than the created date time?
TimeZone is defined on the user.
"Ax utilizes the utcDateTime data type to store date time information in the database using the Greenwich Mean Time definition of time"*
However, while displaying it to the user, it takes into account the user's timezone. In some cases (especially at midnight), the day the user sees and the day kept in sql may be different. Depending on the codes, a situation such as "why it did not come(to report etc.)" may arise.
However, as far as I saw from the other post you opened, your situation is different. Don't rely too much on recIds, the correct field for filters like this is createdDateTime
i'll check on this. does the timezone refer to the aos where the transaction was made?
If you have a date-time range did you consider timezone
thank you for this. are you aware of any cause when fetching in sql, there are missing rec ids. query used is just order by created date time and rec id (for any table)
I don't think there is any control, but due to the nature of ax, considering the places where the values are set, it didn't seem possible to me
#1
André Arnaud de Cal...
293,280
Super User 2025 Season 1
#2
Martin Dráb
232,034
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
All responses (
Answers (
