The function JRTIMESTAMP can be used in any SQL statement to check date values and to convert them into time stamps. This can be relevant when reading process table values because JobRouter date values are stored as Unix Timestamp. Enter the function name followed by the variable e.g. JRTIMESTAMP(invoicedate) for a process table field or JRTIMESTAMP[invoicedate] for a form element. The function ensures that all non-numeric values are removed.
Example:
SELECT * FROM PROCESSTABLE WHERE DATE = JRTIMESTAMP(invoicedate)
