FORMAT_DATE

Convert a date from one format to another

Example Usage

FORMAT_DATE("2021-09-21")   // default masks
FORMAT_DATE("2021-09-21", "%m/%d/%Y")
FORMAT_DATE("2021-09-21", "%m/%d/%Y", "Y-%m-%d") 

Overview

Function signature
FORMAT_DATE(value, mask, targetmask)

Category
Date

Return data type
date

Arguments

Name	DataType	List Options	Description
value	string		Source value as a string
mask	string		Source mask for incoming value
targetmask	string		Target mask for output