EXTRACT_DATE

Syntax

EXTRACT_DATE(<text>)

Description

Extracts dates from text and returns the results in a list.

Examples

EXTRACT_DATE(#Text_Column)

Text columnEXTRACT_DATE returns
Yes, it was her first voyage—she had never been from home before. He won her with his title and his money and his false London ways. If she made a mistake she has paid for it, if ever a woman did. What month did we meet him? Well, I tell you it was just after we arrived. We arrived in June, and it was July. They were married in January of last year. Yes, she is down in the morning-room again, and I have no doubt she will see you, but you must not ask too much of her, for she has gone through all that flesh and blood will stand."[June, January of last year]
"I must explain first," said McFarlane, "that I knew nothing of Mr. Jonas Oldacre. His name was familiar to me, for many years ago my parents were acquainted with him, but they drifted apart. I was very much surprised therefore, when yesterday, about three o'clock in the afternoon, he walked into my office in the city. But I was still more astonished when he told me the object of his visit. He had in his hand several sheets of a notebook, covered with scribbled writing—here they are—and he laid them on my table.[yesterday]
"Well, now I come to the queer part of my story. About a week ago—it was the Tuesday of last week—I found on one of the window-sills a number of absurd little dancing figures like these upon the paper. They were scrawled with chalk. I thought that it was the stable-boy who had drawn them, but the lad swore he knew nothing about it. Anyhow, they had come there during the night. I had them washed out, and I only mentioned the matter to my wife afterwards. To my surprise, she took it very seriously, and begged me if any more came to let her see them. None did come for a week, and then yesterday morning I found this paper lying on the sundial in the garden. I showed it to Elsie, and down she dropped in a dead faint. Since then she has looked like a woman in a dream, half dazed, and with terror always lurking in her eyes. It was then that I wrote and sent the paper to you, Mr. Holmes. It was not a thing that I could take to the police, for they would have laughed at me, but you will tell me what to do. I am not a rich man, but if there is any danger threatening my little woman, I would spend my last copper to shield her."[a week ago, Tuesday of last week, yesterday]
"And now, Mr. Holmes, I come at last to the special thing which has caused me to ask your advice to-day. You must know that every Saturday forenoon I ride on my bicycle to Farnham Station, in order to get the 12:22 to town. The road from Chiltern Grange is a lonely one, and at one spot it is particularly so, for it lies for over a mile between Charlington Heath upon one side and the woods which lie round Charlington Hall upon the other. You could not find a more lonely tract of road anywhere, and it is quite rare to meet so much as a cart, or a peasant, until you reach the high road near Crooksbury Hill. Two weeks ago I was passing this place, when I chanced to look back over my shoulder, and about two hundred yards behind me I saw a man, also on a bicycle. He seemed to be a middle-aged man, with a short, dark beard. I looked back before I reached Farnham, but the man was gone, so I thought no more about it. But you can imagine how surprised I was, Mr. Holmes, when, on my return on the Monday, I saw the same man on the same stretch of road. My astonishment was increased when the incident occurred again, exactly as before, on the following Saturday and Monday. He always kept his distance and did not molest me in any way, but still it certainly was very odd. I mentioned it to Mr. Carruthers, who seemed interested in what I said, and told me that he had ordered a horse and trap, so that in future I should not pass over these lonely roads without some companion.[Saturday, Two weeks ago, Monday, Saturday, Monday]

Example text taken from Return of Sherlock Holmes written by Sir Arthur Conan Doyle

  • This function is not guaranteed to be 100% accurate.
  • The accuracy of results depends on both the training data being used by the function and the comparable quality of input data.
  • In order to assess result accuracy, you need conduct your own performance evaluation.