The DATE() function is used to output a formatted date
Usage:
DATE('format_string', func, offset) - see below for description.
format_string - standard PHP formatting - see https://www.php.net/manual/en/function.strftime.php for more
type - 5 for start of period, and any other value for the current date
offset - offset from the date (backwards). Values could be: 1 day, 2 days, 1 week, 1 month, 1 year
DATE('%d/%m',5)
Returns 11/09 for the 11th of September
DATE('%d/%m',5,'1 week')
Returns 4/09 for the 11th of September