How to extract dates from a document in different formats?
Usually extracting dates from documents begins by selecting a ‘Date‘ as the data field type or applying a ‘Find dates‘ filter by clicking on ‘Add Filter‘ ‘Find …‘ ‘Find dates‘.
‘Find dates‘ filter searches for valid dates in the document based on the format you specify in ‘Format on document’ field as shown below.
You can change the output format of dates by specifying the format in ‘Output format’ field as shown below.
The following table below contains detailed information on the date format syntax used in AlgoDocs.
Day Formatting Syntax
| d | Day of the month without leading zeros | 1 to 31 |
| dd | Day of the month, 2 digits with leading zeros | 01 to 31 |
| s | English ordinal suffix for the day of the month, 2 characters | st, nd, rd or th. Works well with ‘d’ |
Month Formatting Syntax
| M | Numeric representation of a month, without leading zeros | 1 through 12 |
| MM | Numeric representation of a month, with leading zeros | 01 through 12 |
| MMM | A short textual representation of a month, three letters | Jan through Dec |
| MMMM | A full textual representation of a month, such as January or February | January through December |
Year Formatting Syntax
| yyyy | A full numeric representation of a year, 4 digits | e.g. 1991, 2014 |
| yy | A two digit representation of a year | e.g. 14, 19 |
Examples
| Pattern | Value |
| MM/dd/yyyy | 01/24/2021 |
| M/d/yyyy | 1/24/2021 |
| yyyy-MM-dd | 2021-01-24 |
| MMMM d, yyyy | January 24, 2021 |
| ds MMMM yyyy | 24th January 2021 |
| MMM-dd-yy | Jan-24-21 |