Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Manipulating Date data into the proper format

Topic Labels: Base design Data Formulas
625 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator


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:

Screenshot 2023-02-07 at 11.35.35.pngAny 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 😕 

1 Reply 1
18 - Pluto
18 - Pluto

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