Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

D toc


The IFMISMATCHED function writes out a specified value if the input expression does not match the specified data type or typing array. Otherwise, it writes the source value. Input can be a literal, a column reference, or a function.

 The ISMISMATCHED function simply tests if a value is mismatched. See ISMISMATCHED Function.


For data types with formatting options, such as Datetime, you can specify the format using an array, as in the following:

D code

set col: month_Date value: IFMISMATCHED(month_Date, ['Datetime','mm-dd-yy','mm*dd*yy'], null())

Output: Sets values in the month_Date column to be null if they are mismatched against Datetime values in the mm-dd-yy or mm*dd*yy formats.