Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt

Use this file to discover all available pages before exploring further.

Calculates the time difference between two dates. Category: date Syntax: 
DateDiff("unit", [start], [end])
Returns: IntColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
unittext✓ YesThe unit to measure the difference.
startcolumn|datetime✓ YesThe starting date (use Date() to convert if needed).
endcolumn|datetime✓ YesThe ending date (use Date() to convert if needed).
Allowed Values for unit: year, quarter, month, week, day, hour, minute, second, millisecond Allowed Column Types: DATETIME, DATE

​
Validation

  • Minimum parameters: 3
  • Maximum parameters: 3

​
Examples

DateDiff("day", [Invoice Date], Today())
Days between the Invoice Date column and current UTC date. 
DateDiff("year", [Invoice Date], Date("2018-01-01"))
Years between Invoice Date and 2018-01-01. Result: 8 
DateDiff("hour", [Ticket Date], Now())
Hours between Ticket Date and current UTC time. Result: 103
  • DateAdd - Add or subtract time from a date
  • Today - Get current date
  • Now - Get current date and time
Last modified on March 13, 2026