Label Function Syntax: Difference between revisions
| Line 12: | Line 12: | ||
===DATETIME=== | ===DATETIME=== | ||
The function allows you to format a datetime/timestamp field value from the database and display it in the label using the format specified. | |||
<DATETIME(fieldname,dd/MM/yyyy HH:mm:ss)> | |||
===EXPIRYDATE=== | ===EXPIRYDATE=== | ||
===IIF=== | ===IIF=== | ||
Revision as of 08:46, 6 September 2024
There are a number of functions which you can embed in your barcode label template to help format the data before sending to a labeller.
DATE_CREATED
This function returns the date & time when the pallet record was created in the database and allows you to specify the format that you want it formatted in the label.
Example usage
<DATE_CREATED(ddMMyy)>
<DATE_CREATED(dd/MM/yyyy)>
DATETIME
The function allows you to format a datetime/timestamp field value from the database and display it in the label using the format specified.
<DATETIME(fieldname,dd/MM/yyyy HH:mm:ss)>