====== DATE() Function ====== 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 ===== Examples ===== ''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