The function JRDATE can be used in any SQL statement to check date values. To do so enter the function name JRDATE followed by the variable e.g. JRDATE(invoicedate) for a process table field or JRDATE[invoicedate] for a form element. The function ensures that all non-numeric values are removed.
Example:
UPDATE TABLE SET DATE= JRDATE(invoicedate) WHERE …
