Feb 07, 202303:58 AM - edited Feb 07, 202303:59 AM
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 😕
Feb 07, 202306:36 AM - edited Feb 07, 202306:37 AM
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