Yvonne is writing formulas using the following Klipfolio functions: COUNT_DAYS, DATE_ADD, DATE_IN and DATE_STARTOF. What is the input date format Yvonne should use to ensure the Date/Time functions are working correctly?

✅  The correct answer is:

Unix

Question:

Yvonne is writing formulas using the following Klipfolio functions: COUNT_DAYS, DATE_ADD, DATE_IN and DATE_STARTOF. What is the input date format Yvonne should use to ensure the Date/Time functions are working correctly?

Solution:

  • Unix is the default, but any date format can be specified
  • yyyyMMdd
  • Unix
  • All of the above
  • None of the above