Label Function Syntax

From Commander4j
Revision as of 08:46, 6 September 2024 by Dgarratt (talk | contribs) (→‎DATETIME)

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)>

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