ParseDate
=ParseDate(string text; string format, [optional] string CultureInfo) : date
Purpose
Formula to convert text to date and time based on the ISO_8601 format.
The optional CultureInfo argument instructs SeoTools to treat the input string as formatted with a specific culture such as 'en-US'.
Examples
=ParseDate("10.31.2019";"MM.dd.yyyy")
=> 2019-10-31
=ParseDate("2019 jan 1";"yyyy MMM d")
=> 2019-01-01
Get help with this function in the community →