For a variety of reasons, our dates may flow into a report in various formats. My question is whether or not there is a way for a user to reformat a date as a calculated field as part of a pivot. I know that you allow this when the data is coming into the pivot table, but that is not available to the user.
Please see the attached screenshot as an example.
Thank you for reaching out to us.
To start with, we would like to mention that it is highly recommended to use the ISO 8601 date format when passing your data to Flexmonster. Other formats are not officially supported and may lead to unexpected results.
Speaking of redefining the date formats at runtime, please note that this is achievable using the
format property available under the Mapping object. This property allows you to specify a particular date representation format for any date field in your data.
We have prepared a quick JSFiddle example demonstrating how the
format property can be combined with a simple report redefinition to achieve the desired behavior: https://jsfiddle.net/flexmonster/mh2t3afy/
Please let us know if you find our answer helpful.