Label Function Syntax: Difference between revisions
| Line 10: | Line 10: | ||
<DATE_CREATED(dd/MM/yyyy)> | <DATE_CREATED(dd/MM/yyyy)> | ||
If the value of the DATE_CREATED field is null or blank it will return spaces instead of date. | |||
===DATETIME=== | ===DATETIME=== | ||
Revision as of 08:47, 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)>
If the value of the DATE_CREATED field is null or blank it will return spaces instead of date.
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)>