Functions that are available in tiImport Expressions

These functions are available in tiImport expressions only. They are a subset of the TARGIT InMemory
Database SQL functions.

Functions with 1 parameters - DAY | DAYOFWEEK | MONTH | YEAR | ABS | FLOOR | INT | LEN | UCASE |
LCASE | TRIM | LTRIM | RTRIM | SIGN | WEEKDAY

Functions with 2 parameters - LEFT | RIGHT | CONCAT | ENDSWITH | FORMAT

Functions with 3 parameters - DATESERIAL| DATEADD| DATEDIFF | IIF | REPLACE

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.