Extract list of DateTime values within textual value
Returns a list of DateTime
values within the textual value.
Sample usage
EXTRACTDATETIMES("Set a meeting for November 14th at 4pm.")
returns a list of one item: the date and time for November 14 of the current year at 4:00 PM.
EXTRACTDATETIMES("Set a meeting for tomorrow at 4pm.")
returns a list of one item: the date and time for tomorrow at 4:00 PM.
Syntax
EXTRACTDATETIMES(text-to-extract-from)
text-to-extract-from
- Any textual value. May include specific dates and times, dates and times written in prose, and relative dates and times, such astomorrow at 3pm
,yesterday
one hour from now
, etc. See samples above.
See also