Label Function Syntax

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

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

VERSION