Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member


How can I use the date in the Pivot values?


You can follow these steps:
1. Convert the date into an Integer with this chunk of SQL:
2. After you have an Integer representation of a date in the cell use some Jquery to format it the way you want. Using this in the "Edit Script" section:
widget.on('ready', function(){
     $("div.table-grid__tbody div.table-grid__content__inner").map(function(i, cell) {

          var input = cell.innerHTML.replace(/(\d\d\d\d)(\d\d)(\d\d)/, "$2/$3/$1");
          // console.log('input');
          // console.log(input);

          cell.innerHTML = input;


Version history
Last update:
‎10-14-2021 04:08 PM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: