Get Free Trial

Reformat Dates as Calculated Fields

Len Smith asked on April 10, 2020

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.


1 answer

Mykhailo Halaida Mykhailo Halaida Flexmonster April 14, 2020

Hi Len,
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:
Please let us know if you find our answer helpful.
Best regards,

Please login or Register to Submit Answer