• Remember to ensure the commas, brackets, and quotes are being used where needed!

  • IsDateBefore, IsDateAfter, IsDateBetween Functions:
    • This function must use a date in Javascript, so either use a field wrapped in dateCol, or do 'new Date()' around the value you want to use
    • Example: IsDateBefore(dateCol("In Service Date") , new Date("01/01/2017"))

  • Difference between Adding Source Column types:
    • Without Changes: if you want Kurve to read the field type set within TRIRIGA, then use this to add it without changes
    • As a Date: if you want the source column to be interpreted as a date field then always add it as a date
    • As a Number: if you want the source column to be interpreted as a number field then always add it as a number