Here is an example document: Grist
- You can write a formula combining two dates, e.g.
"{} to {}".format($Start, $End)or"{:%Y-%m} to {:%Y-%m}".format($Start, $End)to format only the year and month. - Formatting the date in a formula, e.g.
"{:%Y-%m}".format($Start), means that the column will actually contain only the formatted string. This is different from the date formatting setting in the right panel which doesn’t affect the underlying data. The chart behaves nicely when given data that doesn’t contain a day, and even automatically parses the string back into a datelike object.