How does one store descriptive dates like the "The last day in Feb", "Fourth Saturday in April"?
If you have only a handful of reoccurring descriptive dates, the easiest thing to do would be to create a dictionary that can translate them to the explicit dates you want whenever they pop up in your data.
If you have arbitrary descriptive dates or a large number of them, however, it seems that, as was discussed in the comments, NLP is the way to go.
I have some data that has descriptive dates (e.g., Monday before Thanksgiving, Last day in February, 4th Saturday in April) as part of describing start and end times. Some of the dates are explicit (e.g., October 31st). I want to store the descriptive and the explicit values so for any year I can then calculate when the exact dates are. I did some searching and came up short.
This feels like a common thing, and someone must have solved it.
I'm also curious if these kinds of descriptive dates have a proper name.
As in the tags, my app uses Python + Django.
Thanks!