ezellkendrick

Extracting A Four Digit Year from A  Wide Range of Date Types

Discussion created by ezellkendrick on Jul 6, 2018
Latest reply on Jul 8, 2018 by fmpdude

From an imported file, I need to extract the 4 digit year from a text field based on any type of date formatting that people my choose to create. When 2 four digit years are listed I would have to chose one or the other. Following are some examples:

 

26 Jun 1706

1720

Aug 1728

ABT 1685

About 1821

25th Mar 1813

18th Feb 1739/40

1760-1765

1718-03-10

BET 1790 AND 1795

6-30-1873

22 Sep 1885 or 22 Sep 1886

1780  OR 1790

2 Jul 1746 or 22 Jul 1746?

circa 1750 or 1760

1660 (1666 or 1667??)

Dec 1849 or Bet 1850-1887

Or:1806/05/29-1807/00/00

7/18/1920

Outcomes