Convert text into date and time


#1

date( is locale-specific, which is nice when dealing with user-input. But when importing files I want the same result no matter what. How about an inverse of datepattern(?

For superdates, I can’t find a way to convert from string at all, apart from splitting on maybe whitespace and using date(.


#2

When you want to produce dates in a non locale-specific way, use the datevalue( function.

When using this function it’s up to you to parse the text the way you want, possibly using the array( function or text funnels.

Also, the date( function will convert text in the format YYYY/MM/DD (or YYYY.MM.DD) into a date regardless of the current local. In other words, if the text starts with a four digit year, the date function will always interpret the date using the yyyy/mm/dd format.