Skip to main content
Converts a text or number value to the date data type in ISO date time format Category: conversion Syntax: 
Date(value)
Returns: DateTime Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
valuetext or number or column✓ YesThe value or column containing values to convert to date data values in ISO date time format
Allowed Column Types for value: STRING, TEXT, INT, DATETIME, DATE

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

Date([Invoice Date])
Converts the Invoice Date column to date data type
Last modified on March 13, 2026