====== 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 type - 10 - for a hard coded time (linux timestamp). offset field would be the timestamp itself. You can use this to for example display hours and minutes for run time, etc. Just use DATE('%H:%M',10, 600) for 10 minutes for example. ===== 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