How to format header pivot with the offset of the date

How to format header pivot with the offset of the date

Posted by: yvan-barbaria on 14 September 2017, 11:52 am EST

• 

  yvan-barbaria

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 September 2017, 11:52 am EST

  I have the followin configuration for my PivotPanel, all is fine but when I try to add the offset on the format date, it doesn’t work.

   this._wjPivotPanel.engine = new wjOlap.PivotEngine({
                  autoGenerateFields: false,
                  showZeros: true,
                  itemsSource: this._dataListCube,
                  showColumnTotals: wjOlap.ShowTotals.None,
                  showRowTotals: wjOlap.ShowTotals.None,
                  fields: [
                      { binding: "gridName", header: headerShipper },
                      { binding: "gridPointName", header: headerGridPoint },
                      { binding: "counterpartName", header: headerCounterpart },
                      { binding: "profile", header: headerProfile },
                      { binding: "timeStep", header: headerTimeStep, descending: true, format: "dd/MM/yyyy hh:mm:ss z" },
                      { binding: "value", header: headerValue, format: "n2" }
                  ]
              });

  The result is visible in the attach file.
  
  

• 

  manish-gupta1

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:52 am EST

  Hello Yvan,
  
  Thanks for reporting this issue. We have escalated this issue to the concerned team for further investigation with tracking id 233594. We will update you as soon as we get any notification.

  Thanks,
  
  Manish Kumar Gupta

• 

  yvan-barbaria

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:52 am EST

  Thx Manish !

  Yvan

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 20 January 2018, 6:15 am EST

  Hi Yvan,
  
  We are sorry for the late reply.

  The team have added support for the “z”, “zz”, and “zzz” format specifiers.

  As in .NET, they are interpreted as follows:

  z: hour offset from UTC, one or two digits

  zz: hour offset from UTC, two digits (add leading ‘0’ if necessary)

  zzz: hour:minute offset from UTC

  ~Manish