Contents x
    Datetime_is_same
    • 18 May 2022
    • 1 Minute to read
    • Dark
      Light
    • PDF
    Contents

    Datetime_is_same

    • Updated on 18 May 2022
    • 1 Minute to read
    • Dark
      Light
    • PDF
    Article Summary

    Returns true if the two given datetimes are exactly the same, otherwise returns false.

    Function signature

    DATETIME_IS_SAME(date1: String, date2: String, precision: String) => Boolean
    ParameterDescription
    Date 1Date 1
    Date 2Date 2
    PrecisionPrecision for comparing ("year","month","week","isoWeek","day","hour","minute","second", null)

    Examples

    FormulaReturn value
    DATETIME_IS_SAME("2011-10-10T12:13:14Z", "2011-10-09T12:13:14Z")false
    DATETIME_IS_SAME("2011-10-10T12:13:14Z", "2011-10-10T12:13:14Z")true
    DATETIME_IS_SAME("2011-10-10T12:13:14Z", "2011-10-09T12:13:14Z", "year")true
    Was this article helpful?
    What's Next