Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Reformat Dates as Calculated Fields

Answered
Len Smith asked on April 10, 2020

Hi,
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.
Thanks!!!!

Attachments:
DatePattern.png

1 answer

Public
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: https://jsfiddle.net/flexmonster/mh2t3afy/
 
Please let us know if you find our answer helpful.
 
Best regards,
Mykhailo

Please login or Register to Submit Answer