Date Formatting Problem

[Isaias Chalvatzoglou]

Good Afternoon.

In your documentation https://ej2.syncfusion.com/angular/documentation/pivotview/how-to/customize-number-date-and-time-values/ you say that we can customize date and time formatting. On preview tab i see that all dates have the same value (01/01/1970-02:00).

 formatSettings: [{ name: 'Sold', format: 'dd/MM/yyyy-hh:mm', type: 'date' }],

I need to make a pivot grid like this and i found out that the problem really exists.

The real date values are 18-06-2019 09:22, 18-06-2019 10:15 e.t.c.

[Jagadeesan Pichaimuthu]

Hi Isaias, 

  

Currently, we don’t have option to format date in value axis directly using formatSettings. But, you can display the date in values by using aggregationCellInfo event. Please refer the following code snippet. 

 

Code Snippet: 

aggregateCellInfo(args) { 

    if (args.columnCellType == 'grandTotal') { 

      args.value = ''; 

      for (var i = 0; i < args.cellSets.length; i++) { 

        if (typeof (args.cellSets[i][args.fieldName]) == "number") { 

          args.value = args.value + args.cellSets[i][args.fieldName]; 

        } 

      } 

    } else if (args.cellSets[0]) { 

      args.value = args.cellSets[0][args.fieldName]; 

    } 

  } 

  

  

Sample: https://stackblitz.com/edit/angular-kf9lrw?file=main.ts 

  

Note: We formatted the Sold Amount (Number) into the date in the document. Number regarded as count in this case. If the count is the same for all numbers, all values will display the same date. 

  

Please let us know if you need further assistance on this. 

  

Regards, 

Jagadeesan

[Isaias Chalvatzoglou]

Hi Jagadeesan,

Problem solved.

Thank you for your quick response!

[Isaias Chalvatzoglou]

Hello again.

When I'm exporting same pivot grid to excel, date saved in the excel as '2019-06-20T06:22:00'. There is a way datetime to be saved like the formatting i defined in format settings 'dd/MM/yyyy hh:mm' ?

[Jagadeesan Pichaimuthu]

Hi Isaias, 

  

You can achieve your requirement using beforeExcelExport event. Please refer following code snippet. 

  

Code Snippet: 

dataBound(args): void { 

    this.pivotGridObj.grid.beforeExcelExport = function (args) { 

      var data = (args as any).gridObject.dataSource; 

      for (var i = 0; i < data.length; i++) { 

        for (var j = 0; j < Object.keys(data[i]).length; j++) { 

        if (data[i][j].axis == 'value') { 

          data[i][j].value = data[i][j].formattedText; 

        } 

      } 

    } 

  } 

} 

  

Sample: https://stackblitz.com/edit/angular-kf9lrw?file=app.component.ts 

  

Please let us know if you need further assistance on this. 

  

Regards, 

Jagadeesan

[Isaias Chalvatzoglou]

Hi Jagadeesan,

It works!

Thank you

[Dinesh Babu Yadav]

Hi Isaias, 

 

Thanks for the update. Please get back to us if you need further other assistance from us. 

 

Regards, 

Dinesh Babu Yadav