What is the result of the following formula? DATEVALUE( DATE_STARTOF( DATE_ADD( DATE(“2017-11-15″,”yyyy-MM-dd”), year, “-1”), quarter), “yyyyMMdd”)

✅  The correct answer is:

20161001

Question:

What is the result of the following formula? DATEVALUE( DATE_STARTOF( DATE_ADD( DATE(“2017-11-15″,”yyyy-MM-dd”), year, “-1”), quarter), “yyyyMMdd”)

Solution:

  • 20161115
  • 2017-10-01
  • 2017-01-01
  • 20161001