Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-5963

Date Picker showing One Day Prior for Default Value of =TODAY and =YESTERDAY when client is in Different Timezone

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 7.0.0.4 GA, 7.1.0.5 GA, 8.0.0 GA
    • Fix Version/s: 8.2.0 GA
    • Component/s: None
    • Labels:
    • Environment:
      Windows 10
      PUC
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Tatooine (Maint)
    • Operating System/s:
      Ubuntu 9.x (64-bit)
    • Steps to Reproduce:
      Hide
      • Create a simple PRD report with a Start and End date Date Picker parameters or use the e attached PRD report.
      • Set each Date Picker parameter's Timezone to "Use Client timezone" and the Default Value Formula to =YESTERDAY() for StartDate and =TODAY() for EndDate
      • Open a VM with pentaho-server installed and be sure the server time is set to Central Time.
      • Start the server and upload the PRD report
      • Open the report to validate the default start and end dates for the parameters are today and yesterday.
      • Open the report in another window
      • Copy the URL (note the server's IP address)
      • Be sure the client OS is set to another timezone (i.e. Eastern Time)
      • Using the server's IP address, call the report from the client machine.
      • Notice the start and end date parameters are a day earlier.
      • If the timezones are switched where the server is earlier than the client then if the report is opened on the server then its parameter's dates will be wrong and the client's dates will be correct for today and yesterday.

      Workaround:
      Leave Timezone blank or with "Use Server timezone"

      Show
      Create a simple PRD report with a Start and End date Date Picker parameters or use the e attached PRD report. Set each Date Picker parameter's Timezone to "Use Client timezone" and the Default Value Formula to =YESTERDAY() for StartDate and =TODAY() for EndDate Open a VM with pentaho-server installed and be sure the server time is set to Central Time. Start the server and upload the PRD report Open the report to validate the default start and end dates for the parameters are today and yesterday. Open the report in another window Copy the URL (note the server's IP address) Be sure the client OS is set to another timezone (i.e. Eastern Time) Using the server's IP address, call the report from the client machine. Notice the start and end date parameters are a day earlier. If the timezones are switched where the server is earlier than the client then if the report is opened on the server then its parameter's dates will be wrong and the client's dates will be correct for today and yesterday. Workaround: Leave Timezone blank or with "Use Server timezone"

      Description

      PRD Date Picker start and end dates are reflecting one day prior to the days they should reflect when the Date Picker's time zone is set to "Use Client timezone" and the client and server are in different time zones.
      For example:
      Client (Eastern Time Zone)
      Server (Central Time Zone)

      Note: This does not occur if the Date Picker's time zone is blank or "Use Server timezone".

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              scosta Sandra Costa
              Reporter:
              porchard Paul Orchard-Hays (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: