ParseDate

=ParseDate(string text; string format,  [optional] string CultureInfo) : date

Results from function inside Excel


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

See

Related Functions


Get help with this function in the community →