Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

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

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

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 – 
For the simplicity, we have used JSON in the sample, but this approach works with other data sources as well.
Hope it helps.

This question is now closed