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

Examples

EXTRACTTIMES("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)

EXTRACTTIMES("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 time of writing this 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(), EXTRACTDATETIMES(), EXTRACTDURATIONS(), EXTRACTEMAILS(), EXTRACTHASHTAGS(), EXTRACTMENTIONS(), EXTRACTNUMBERS(), EXTRACTPHONENUMBERS(), EXTRACTPRICES()

Did this answer your question?