Page tree


Support | BlogContact Us | 844.332.2821

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


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: validDate value: IFVALID(myDate, ['Datetime','mm-dd-yy','mm*dd*yy'], 'true')

Output: Sets the values in the the validDate column to true, if the corresponding value in the myDate column is a valid Datetime value in yy-mm-dd or yy*mm*dd format.