ArabicChinese (Simplified)DutchEnglishFilipinoFrenchGermanHindiItalianPortugueseRussianSpanishTurkish
Share on email
Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on telegram
Share on whatsapp

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 Comment

Your email address will not be published. Required fields are marked *