Match the Klipfolio Date and Time Functions below with the common use case where you would use them.

  • DATE​— = — Used to convert a human readable date string (2015/01/01), into a computer readable date string known as Epoch or Unix time. Correct
  • DATEVALUE​— = — Used to convert an Epoch or Unix date/time (computer readable date string) into a human readable date string (2015/01/01). Correct
  • DATE_IN​— = — Used to find dates that fall within a given time period, like day, week, month, quarter, year. Correct
  • DATE_ADD​— = — Used to add or subtract a certain number of units (seconds, minutes, days, etc.) to a given date in order to arrive at a different date. Correct
  • DATE_CONVERT​— = — Used to change the format of one human readable date string (2015/01/01) to another human readable date string (Jan 1, 2015), often for the purposes of sorting. Correct
  • DATE_STARTOF — = — Returns the first date of a given date period, like week, month, quarter, year.

Leave a Reply