We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

How to display date and time in a measure cell

Answered
Ahmed asked on July 10, 2019

Hello,
How to display date and time in a measure cell without replacing text in cell.text
Thank you.

1 answer

Public
Vera Didenko Vera Didenko Flexmonster July 10, 2019

Hello, Ahmed,
 
Thank you for your question.
 
Date and time can be displayed in a measure cell by specifying the appropriate data type.
Please consider using the datetime JSON data type for Fields containing date-time values.
The datetime data type is a date field that can be used for values in the pivot table. Min, max, count, and distinct count aggregations can be applied to this field.
Please see our date and time formatting tutorial for more information.
 
Here is a JSFiddle example for illustration.
 
Please let us know if you have further questions.
 
Best Regards,
Vera

Please login or Register to Submit Answer