Examples

EXTRACTDATETIMES("Set a meeting for November 14th at 4pm.") : a list of one item: the date & time for November 14 of the current year at 4:00 PM.

EXTRACTDATETIMES("Set a meeting for tomorrow at 4pm.") : a list of one item: the date & time for tomorrow at 4:00 PM.

Syntax

EXTRACTDATETIMES( text-to-extract-from )

Arguments

text-to-extract-from (any textual): may include 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. See examples.

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?