How do we suppress day and just have year, quarter, month?

posted on March 14th, 2018

Closed

Sandip Savalia asked on March 14, 2018

D+ field is a date. You will see such date as a hierarchy: Year > Month > Day.
D4+ field is a date. You will see such date as a hierarchy: Year > Quarter > Month > Day.

We want to use something like D4+, but do not want the Day option or column. What is the best way to achieve this?

1 answer

Public

Ian Sadovy ⋅ Flexmonster ⋅ March 15, 2018

Hello Sandip,

Thank you for the question.
Currently, you can control dates only with predefined formats such as D+, D4+, d+, ds+ and cannot change them.
As a workaround, it is possible to use D4+ and simply hide "+ Day" link using `customizeCell` function, so the days won't be visible.
Please check the following sample - http://jsfiddle.net/flexmonster/s3n1skny/
For the simplicity, we have used JSON in the sample, but this approach works with other data sources as well.

Hope it helps.

Regards,
Ian

This question is now closed