2

You can use the LAST_DAY function if you're working with MySQL. To only get entries with a postDate on the last day of the month, you can check if LAST_DAY(postDate) is identical with DATE(postDate). {% set lastDayOfMonthEntries = craft.entries() .andWhere('LAST_DAY([[postDate]]) = DATE([[postDate]])') .all() %} Add further query parameters to limit ...


Only top voted, non community-wiki answers of a minimum length are eligible