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