- Valid Date Format Keywords
The following table shows the keywords for valid formats, with a description and example of each.
- ABS macro
The ABS
macro is available only in Unica Campaign.
- ACOS macro
The ACOS
macro is available only in Unica Campaign.
- ACOT macro
The ACOT
macro is available only in Unica Campaign.
- ADD_MONTHS macro
The ADD_MONTHS
macro is available in Unica Campaign
- AND macro
The AND
macro is available in Unica Campaign and Unica Interact.
- ASIN macro
The ASIN
macro is available only in Unica Campaign.
- ATAN macro
The ATAN
macro is available only in Unica Campaign.
- AVG macro
The AVG
macro is available in Unica Campaign and Unica Interact.
- BETWEEN macro
The BETWEEN
macro is available only in Unica Campaign.
- BIT_AND macro
The BIT_AND
macro is available in Unica Campaign and Unica Interact.
- BIT_NOT macro
The BIT_NOT
macro is available in Unica Campaign and Unica Interact.
- BIT_OR macro
The BIT_OR
macro is available in Unica Campaign and Unica Interact.
- BIT_XOR macro
The BIT_XOR
macro is available in Unica Campaign and Unica Interact.
- CEILING macro
The CEILING
macro is available only in Unica Campaign.
- COLUMN macro
The COLUMN
macro is available only in Unica Campaign.
- COS macro
The COS
macro is available only in Unica Campaign.
- COSH macro
The COSH
macro is available only in Unica Campaign.
- COT macro
The COT
macro is available only in Unica Campaign.
- COUNT macro
The COUNT
macro is available only in Unica Campaign.
- CURRENT_DATE macro
The CURRENT_DATE
macro is available in Unica Campaign and Unica Interact.
- CURRENT_DAY macro
The CURRENT_DAY
macro is available in Unica Campaign and Unica Interact.
- CURRENT_JULIAN macro
The CURRENT_JULIAN
macro is available only in Unica Campaign.
- CURRENT_MONTH macro
The CURRENT_MONTH
macro is available in Unica Campaign and Unica Interact.
- CURRENT_TIME macro
The CURRENT_TIME
macro is available only in Unica Campaign.
- CURRENT_WEEKDAY macro
The CURRENT_WEEKDAY
macro is available in Unica Campaign and Unica Interact.
- CURRENT_YEAR macro
The CURRENT_YEAR
macro is available in Unica Campaign and Unica Interact.
- DATE
- DATE_FORMAT macro
The DATE_FORMAT
macro is available in Unica Campaign and Unica Interact.
- DATE_JULIAN macro
The DATE_JULIAN
macro is available only in Unica Campaign.
- DATE_STRING macro
The DATE_STRING
macro is available only in Unica Campaign.
- DAY_BETWEEN macro
The DAY_BETWEEN
macro is available only in Unica Campaign.
- DAY_FROMNOW macro
The DAY_FROMNOW
macro is available only in Unica Campaign.
- DAY_INTERVAL macro
The DAY_INTERVAL
macro is available only in Unica Campaign.
- DAYOF macro
The DAYOF
macro is available only in Unica Campaign.
- DISTANCE macro
The DISTANCE
macro is available in Unica Campaign and Unica Interact.
- DIV macro
The DIV
macro is available in Unica Campaign and Unica Interact.
- EQ macro
The EQ
macro is available in Unica Campaign and Unica Interact.
- EXP macro
The EXP
macro is available only in Unica Campaign.
- EXTERNALCALLOUT macro
The EXTERNALCALLOUT
macro is available only in Unica Interact.
- FACTORIAL macro
The FACTORIAL
macro is available only in Unica Campaign.
- FLOOR macro
The FLOOR
macro is available only in Unica Campaign.
- FORMAT macro
The FORMAT
macro is available only in Unica Campaign.
- FRACTION macro
The FRACTION
macro is available only in Unica Campaign.
- GE macro
The GE macro is available in Unica Campaign and Unica Interact.
- GET macro
The GET macro is available in Unica Interact.
- GROUPBY macro
The GROUPBY
macro is available only in Unica Campaign.
- GROUPBY_WHERE macro
The GROUPBY_WHERE
macro is available only in Unica Campaign.
- GT macro
The GT
macro is available in Unica Campaign and Unica Interact.
- IF macro
The IF
macro is available in Unica Campaign and Unica Interact.
- IN macro
The IN
macro is available in Unica Campaign and Unica Interact.
- INT macro
The INT
macro is available only in Unica Campaign.
- INVERSE macro
The INVERSE
macro is available only in Unica Campaign.
- IS macro
The IS
macro is available in Unica Campaign and Unica Interact.
- ISERROR macro
The ISERROR
macro is available only in Unica Campaign.
- ISODD macro
The ISODD
macro is available only in Unica Campaign.
- ISEVEN macro
The ISEVEN
macro is available only in Unica Campaign.
- ISODD macro
The ISODD
macro is available only in Unica Campaign.
- LE macro
The LE
macro is available in Unica Campaign and Unica Interact.
- LIKE macro
The LIKE
macro is available in Unica Campaign and Unica Interact.
- LN or LOG macro
The LN
or LOG
macro is available only in Unica Campaign.
- LOG2 macro
The LOG2
macro is available only in Unica Campaign.
- LOG10 macro
The LOG10
macro is available only in Unica Campaign.
- LOWER macro
The LOWER
macro is available in Unica Campaign and Unica Interact.
- LT macro
The LT
macro is available in Unica Campaign and Unica Interact.
- LTRIM macro
The LTRIM
macro is available in Unica Campaign and Unica Interact.
- MAX macro
The MAX
macro is available in Unica Campaign and Unica Interact.
- MEAN macro
The MEAN
macro is available in Unica Campaign and Unica Interact.
- MIN macro
The MIN macro is available in Unica Campaign and Unica Interact.
- MINUS macro
The MINUS
macro is available in Unica Campaign and Unica Interact.
- MOD macro
The MOD
macro is available in Unica Campaign and Unica Interact.
- MONTHOF macro
The MONTHOF
macro is available only in Unica Campaign.
- MULT macro
The MULT
macro is available in Unica Campaign and Unica Interact.
- NE macro
The NE
macro is available in Unica Campaign and Unica Interact.
- NOT macro
The NOT
macro is available in Unica Campaign and Unica Interact.
- NUMBER macro
The NUMBER macro is available in Unica Campaign and Unica Interact.
- OR macro
The OR
macro is available in Unica Campaign and Unica Interact.
- POSITION macro
The POSITION
macro is available only in Unica Campaign.
- PLUS macro
The PLUS
macro is available in Unica Campaign and Unica Interact.
- POWER macro
The POWER
macro is available in Unica Campaign and Unica Interact.
- RANDOM macro
The RANDOM
macro is available only in Unica Campaign.
- RANDOM_GAUSS macro
The RANDOM_GAUSS
macro is available only in Unica Campaign.
- ROUND macro
The ROUND
macro is available only in Unica Campaign.
- ROWNUM macro
The ROWNUM
macro is available only in Unica Campaign.
- RTRIM macro
The RTRIM macro is available in Unica Campaign and Unica Interact.
- SIGN macro
The SIGN
macro is available only in Unica Campaign.
- SIN macro
The SIN
macro is available only in Unica Campaign.
- SINH macro
The SINH
macro is available only in Unica Campaign.
- SIZE macro
The SIZE macro is available in Unica Interact.
- SORT macro
The SORT macro is available in Unica Interact.
- SQRT macro
The SQRT
macro is available only in Unica Campaign.
- STDV or STDEV macro
The STDV
or STDEV
macro is available in Unica Campaign and Unica Interact.
- STRING_CONCAT macro
The STRING_CONCAT
macro is available in Unica Campaign and Unica Interact.
- STRING_HEAD macro
The STRING_HEAD
macro is available only in Unica Campaign.
- STRING_LENGTH macro
The STRING_LENGTH
macro is available only in Unica Campaign.
- STRING_PROPER macro
The STRING_PROPER
macro is available only in Unica Campaign.
- STRING_SEG macro
The STRING_SEG
macro is available only in Unica Campaign.
- STRING_TAIL macro
The STRING_TAIL
macro is available only in Unica Campaign.
- SUBSTR or SUBSTRING macro
The SUBSTR
or SUBSTRING
macro is available in Unica Campaign and Unica Interact.
- SUM macro
The SUM
macro is available in Unica Campaign and Unica Interact.
- TAN macro
The TAN
macro is available only in Unica Campaign.
- TANH macro
The TANH macro is available only in Unica Campaign.
- TOTAL macro
The TOTAL
macro is available in Unica Campaign and Unica Interact.
- TRUNCATE macro
The TRUNCATE
macro is available only in Unica Campaign.
- UPPER macro
The UPPER
macro is available in Unica Campaign and Unica Interact.
- VARIANCE macro
The VARIANCE
macro is available only in Unica Campaign.
- WEEKDAY macro
The WEEKDAY macro is available only in Unica Campaign.
- WEEKDAYOF macro
The WEEKDAYOF macro is available only in Unica Campaign.
- XOR macro
The XOR macro is available in Unica Campaign and Unica Interact.
- YEAROF macro
The YEAROF macro is available only in Unica Campaign.