This is an old revision of the document!
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('HH:MM',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
