In Layup, you can use functions for the output date and for date formats. To enter a function, start with "=". The available functions are TODAY and DATE_FORMAT.
Functions
- TODAY(format)
- Returns today's date in the specified format. Enclose the format in double quotation marks. If the format is omitted, the date is returned in the "Y-m-d" format.
- DATE_FORMAT(date, format)
- Converts a date to the specified format and returns it. Specify "%field code%" for the date, and enclose the format in double quotation marks. If the value cannot be read as a date, the cell is left blank.
In the format, you can use Y (4-digit year), y (2-digit year), m (2-digit month), d (2-digit day), H (24-hour), h (12-hour), i (2-digit minutes), s (2-digit seconds) and w (day of the week). The following examples print, from the top, the output date and the date in the field (InvoiceDate) in the "10/08/2026" format.
=TODAY("m/d/Y")
=DATE_FORMAT(%InvoiceDate%, "m/d/Y")
To print a calculated date, a number with thousands separators and so on, save the calculation result in a field with Boost! Action before output, and embed that field.
Save calculation results in fields with Boost! Action +