EXTRACTDATES() Two-Argument Form

EXTRACTDATES() in its current state is not a good fit for precise application with highly variable text.

In this example
EXTRACTDATES("10.03.2021 Text 2000 Text 04/05/2006 Text 1900 Text 2050 Text")
it will find:
10.03.2021 , 01.01.2000 , 01.01.2001 , 05.04.2006 , 01.01.1900 , 01.01.1901 , 01.01.2050 , 01.01.2051
Why? AppSheet Support told me:

  • it considers four digit integers 1900-2050 (inclusive) to be valid years
  • it detects 2001 as the range of dates in the year 2000, from 1/1/2000 to 1/1/2001 (the same for 1901 and 2051)

I would like to have a Two-Argument Form like we have in TEXT() Expression.
For example:
EXTRACTDATES("10.03.2021 Text 2000 Text 04/05/2006 Text 1900 Text 2050 Text" , "DD.MM.YYYY)
Would only give me one result: 10.03.2021

Status Open
1 1 136