EXTRACTDATES()

Returns list of Date values within a textual value.

Sample usage

EXTRACTDATES("Set a meeting for November 14th at 4pm.") returns a list of one item: the date of November 14 of the current year.

EXTRACTDATES("Set a meeting for tomorrow.") returns a list with one item: tomorrow's date.

EXTRACTDATES("Yesterday, today, and tomorrow.") returns a list with thee items: the dates equivalent to (TODAY() - 1), TODAY(), and (TODAY() + 1).

EXTRACTDATES("1 month 3 days ago; 7 years 2 months 4 days ago; 2 weeks from tomorrow; in 4 days") returns a list with the corresponding relative dates.

EXTRACTDATES("first of last month; first of this month; first of next month; 15th of this month; first day of next year") returns a list with the corresponding relative dates.

EXTRACTDATES("Monday; last Monday; this Monday; next Monday; Monday 2 weeks from now") returns a list with the corresponding relative dates.

EXTRACTDATES("March") returns a list with two dates, the first day of the given month of the current year and the first day of the following month: 3/1/2021, 4/1/2021.

EXTRACTDATES("2020") returns a list with two dates, the first day of the given year and the first day of the following year: 1/1/2020, 1/1/2021. Any four-digit value between 1900 and 2050 (inclusive) are handled as such.

Syntax

EXTRACTDATES(text-to-extract-from)

• text-to-extract-from - Any textual value. May include specific dates, dates written in prose, relative dates (such as tomorrow or yesterday), day and month names, and bare 4-digit year numbers. See samples above.

See also

Date and time expressions

EXTRACT()

EXTRACTCHOICE()

EXTRACTDATETIMES()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

EXTRACTPHONENUMBERS()

EXTRACTPRICES()

EXTRACTTIMES()