Category

String Functions

Description

Convert a string to a date value

Syntax

ToDate(string)

Parameters

string - a literal string or string function result that can be parsed as a date

Notes

The following date formats can be parsed by this function:

yyyymmdd (as a string)

mm/dd/yy or mm/dd/yyyy, where mm and dd are either 1 or 2 digits

dd-mmm-yy or dd-mmm-yyyy, where mmm is Jan, Feb, etc. (not case-sensitive)

If the string is not a valid date, the result will be 0.

 

 

 

 

Copyright © 2020-2021 Systematic Solutions, LLC