Extract all dates and times from a text field. Note that this includes specific dates and times, dates and times written in prose, and relative dates and times, such as “tomorrow at 3pm”, “yesterday,” “one hour from now”, etc.

Examples

EXTRACTDATETIMES("Set a meeting for November 14th at 4pm."): LIST(DATETIME("11/14/2019 16:00:00")) (replace 2019 with whatever the current year is, if you're reading this in the future)

EXTRACTDATETIMES("Set a meeting for tomorrow at 4pm.") : A DateTime value set to whatever the current date is, plus one day, at 4pm. For example, at the time of writing this document it is 11/05/19, and so the result would be LIST(DATETIME("11/06/2019 16:00:00"))

Syntax

EXTRACTDATETIMES(“text-to-extract-from”)

Arguments

text-to-extract-from (text)

Return Value

A list of DateTime values. 

See Also

EXTRACT(), EXTRACTCHOICE(), EXTRACTDATES(), EXTRACTDURATIONS(), EXTRACTEMAILS(), EXTRACTHASHTAGS(), EXTRACTMENTIONS(), EXTRACTNUMBERS(), EXTRACTPHONENUMBERS(), EXTRACTPRICES(), EXTRACTTIMES()

Did this answer your question?