Greetings,
I've got a tricky date string that I'm having trouble with in converting to an actual DATE. Kibana is kicking out date strings such as the following: July 22nd 2019 and August 21st 2019 I've played around with "Text to Column" and various functions but to no avail. I don't see any examples here that are quite like mine. It needs to apply to different month lengths and dump the "nd" and "st", etc..... Any ideas out there how to convert this column of data to an actual DATE type format?
Thanks much,
Mark
Bookmarks