Manipulating Date data into the proper format

[Alec]

Hello,

I have a web scraper that is pulling in assorted data from a list of projects. The issue being that the date/time data that it scrapes into my base doesn't convert very well into an actual date field type.

Here is what I am working with:

Any ideas on how i can remedy this? I need the date field type so i can better filter the projects.

Also welcome to any suggestions on how to best handle the "Bids In" column where it gives me varied answers that don't filter very well 😕 

[TheTimeSavingCo]

What about creating a formula field per field of date data, and using `DATETIME_PARSE()` on them?  You'd need to be wary of time zone issues though, and might need to use `DATEADD()` depending on the time zone of the date data

re: the "Bids In" column
I'd use formula fields with a `FIND()` to categorize them and output the days so that I could filter them I reckon