Forum Stats

  • 3,826,341 Users
  • 2,260,630 Discussions
  • 7,896,908 Comments

Discussions

Report pulling in dates as date -1 day for one user only

3668012
3668012 Member Posts: 2
edited May 13, 2020 12:27PM in Reports

I have a user who reported the enterprise hire date, legal hire date, legal seniority date and enterprise seniority date are pulling out of Oracle as the actual date minus one day. I thought she had a formula or macro but it's pulling straight out of Oracle under her user log in only. She has the same role access as her boss who is able to pull the report without issue. Going to open SR but thought I'd open up  this issue in case anyone else knows what I need to do to correct.

Answers

  • 3668012
    3668012 Member Posts: 2
    edited May 13, 2020 12:27PM

    SR/Oracle noted that by default the system will pull the reports based on the server timezone which is UTC timezone. But if the user setup the timezone to any other timezone than UTC in their user preferences, then BI will pull the reports based on user preferences.

    Is there no way to default the system to run reports only off of the server timezone?