Date.FromText

About

Returns a Date value from a set of date formats and culture value, following ISO 8601 format standard.

Syntax

Date.FromText(date as nullable text, optional culture as nullable text) as nullable date  

Arguments

Argument Description
date A string value to transorm.
optional culture A text value corresponding to the culture values supported on your version of Windows, such as "en-US". If the culture is not specified, the current user culture is used. For a list of culture names, see National Language Support (NLS) API Reference.

Supported formats

  • yyyy-MM-dd

  • YYYYMMDD

  • M/d/yyyy

Terms

  • Y = years

  • M = months

  • D = days

Remarks

  • If the culture is not specified, the current user culture is used.

Example

Date.FromText("2010-02-19") equals Date,yyyy-MM-dd