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

How to display time in separate column in pivot?

Answered
Nikhil Bhadake asked on May 14, 2018

Hi,
Currently I display date in pivot. Flexmonster displays date in three columns viz YEAR, MONTH and DATE.
In certain cases, application input changes from date to date time. In this case, I want to display fourth column for time.
Is there any demo available for such scenarios or How can I achieve this behavior?
 
Thanks
Nikhil Bhadake

1 answer

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster May 15, 2018

Hello Nikhil,
Thank you for your question. Our date hierarchy does not support time level. In such case, we recommend setting datetime data type for your dates with applying an appropriate dateTimePattern. Please find more information in our documentation: https://www.flexmonster.com/doc/date-and-time-formatting/.
Let us know if it works for you.
Regards,
Dmytro

Please login or Register to Submit Answer