Label Function Syntax: Difference between revisions
Created page with "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=== ===DATETIME=== ===EXPIRYDATE=== ===IIF=== ===JULIAN_YJJJ=== ===LEFT=== ===LOWERCASE=== ===LTRIM=== ===PADLEFT=== ===PADRIGHT=== ===PALLET_WEIGHT_BARCODE=== ===PALLET_WEIGHT_TEXT=== ===PRODDATE=== ===RIGHT=== ===RTRIM=== ===SUBSTRING=== ===SUBTR_LPAD=== ===TIMESTAMP=== ===TRIM=== ===UPPERCASE=== ===USERNAME=== ===VERS..." |
|||
| Line 2: | Line 2: | ||
===DATE_CREATED=== | ===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=== | ===DATETIME=== | ||
===EXPIRYDATE=== | ===EXPIRYDATE=== | ||
Revision as of 08:41, 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)>