Hi All,
I'm running a Jet Report and run Microsoft Nav. I'm finding the time coming into my report is 8 hours after my date in NAV. My time in the object designer says 12:00pm which is correct but when it comes through on my JetReport it says 8:00pm. Does anyone have any suggestions as to why this is occurring? It has me perplexed :?
I have also noticed this happens on the iPad App also so I'm assuming it has something to do with a setting somewhere.
Thanks in Advance
Lisa
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi Lisa,
I have come across this issue before. In the background, NAV stores time data in GMT/UTC time zone in the tables. If you are pulling the data into Jet, you will need to adjust for your time zone. To do this, just use a formula to add or remove the number of hours to reach the correct time result (for instance, if your time is 4 hours different, add +4/24 to the formula).
The other thing you may need to consider is Daylight Savings adjustments. I got around this by adding a report option to select either Daylight Savings or standard time. You can then do an IF statement on the time field to return the correct time based on the option selection.
Jill -
Jet Reports Historic Posts Thanks for your prompt reply UserJill!
-
Jet Reports Historic Posts I've got news on this, development looked into it and if everything's going to plan this will be fixed in the upcomming release.
-
Herke Dekker Hi Jet, I'm running into the same problem. Have you already solved this problem in a new version of Jet in the meantime?
-
Sutikno Darmohusodo it was fixed before, up to 21.2 Build 21.2.21112.1 but came back on the latest build 21.4.22025.1
I uninstalled the latest one and reinstalled 21.2 and now it works as expected.
Please sign in to leave a comment.