EXTRACTDATETIMES()

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 as tomorrow at 3pm, yesterday one hour from now, etc. See samples above.

See also

Date and time expressions

EXTRACT()

EXTRACTCHOICE()

EXTRACTDATES()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

EXTRACTPHONENUMBERS()

EXTRACTPRICES()

EXTRACTTIMES()

 

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false