Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

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

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