CALENDARAUTO simply generates the list of dates. These dates automatically cover all dates, that can be found in any table of data model - or, I mean, all the years with this dates.


Additional info:

  • The CALENDAR function works similarly, but you have to define the first and last date manually.
  • CALENDARAUTO can have an argument, integer 1-12, declaring, which month is the last mont of fiscal year - then the dates will be generated for these fiscal years.

Leave a Reply

Your email address will not be published.


clear formPost comment