Drivetrain Knowledge Hub
  • Getting started
    • Start here
      • Navigating Drivetrain
      • Key terms & concepts
    • Reports
      • Interacting with reports
      • Creating a report
      • Collaborating on a report
    • Data
      • Connecting data sources
      • Explore your datasets
      • Transforming and enriching data
    • Metrics
      • Metric Builder overview
      • Creating a metric from a dataset
      • Creating a metric using formula
      • Adding dimensions
    • Models
  • Modeling
    • Models page overview
    • Creating a model
    • Formatting a variable
    • Adding plan/forecast numbers to a variable
    • Lists overview
    • Adding dimensions to a model
    • Saving and managing versions
    • Creating and comparing scenarios
    • Setting up reconciliation workflows
    • Collaborating on models (commenting)
    • More model elements
    • Practical example
  • Formulas
    • Formulas in Drivetrain
      • Referencing metrics in formulas
      • Operators
      • Functions
        • ABS
        • AND
        • AVERAGE
        • BLANK
        • BOMONTH
        • CEIL
        • COLLAPSE
        • CONCAT
        • DATE
        • DATEADD
        • DATEDIFF
        • DATEVALUE
        • DAY
        • DAYSINMONTH
        • EOMONTH
        • EQUALS (or EQ)
        • EVEN
        • FINANCIALYEARSTARTMONTH
        • FLOOR
        • FORECAST
        • IF
        • ISBLANK
        • LAST ACTUALS DATE
        • LOOKUP
        • LOWER
        • MAX
        • MID
        • MIN
        • MOD
        • MONTH
        • NETWORKDAYS
        • NOT
        • ODD
        • OR
        • PERIOD
        • PRORATA
        • QUARTERTODATE
        • ROUND
        • ROUNDDOWN
        • ROUNDUP
        • SLN
        • SUM
        • SUMMARIZE
        • THIS MONTH
        • TODAY
        • VALUE
        • UPPER
        • YEAR
        • YEARTODATE
  • User Administration and Access
    • Access control & permissions
      • Creating a user
      • Creating and managing roles
      • Understanding permissions in roles
      • Reviewing user permissions
    • Data masking
  • Data Governance
    • How Drivetrain ensures data quality
  • Integration guide
    • Integrate with Drivetrain
  • 📡Extending Drivetrain
    • Drivetrain API
      • Get metric list API
      • Get metric data API
    • Export to data warehouses
      • Export to BigQuery
    • Google Sheets add-on
    • Integration for Slack
Powered by GitBook
On this page

Was this helpful?

  1. Formulas
  2. Formulas in Drivetrain
  3. Functions

DATEDIFF

Returns the difference between two dates in the units (days, months, or years) specified.

Syntax: DATEDIFF( start_date, end_date, interval )

  • start_date and end_date are the two dates to calculate the difference between.

  • interval is the units in which the DATEDIFF function reports the difference between the two dates. It can take one of the following values:

    1. “Y” for year

    2. “M” for month

    3. “D” for days

Note: All three arguments (parameters) are required.

Example: DATEDIFF ( DATE ( 2022 , 1 , 1 ) , DATE ( 2022 , 12 , 31 ) , "D" ) Output: 364

Example: DATEDIFF ( DATE ( 2022 , 1 , 1 ) , DATE ( 2022 , 12 , 31 ) , "M" ) Output: 11

Example: DATEDIFF ( DATE ( 2022 , 1 , 1 ) , DATE ( 2022 , 12 , 31 ) , "Y" ) Output: 0

PreviousDATEADDNextDATEVALUE

Last updated 6 months ago

Was this helpful?