Skip to main content

Manipulating Date data into the proper format

  • February 7, 2023
  • 1 reply
  • 0 views
Alec11
  • Alec11
  • Participating Frequently
  • 9 replies

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 😕😕 

1 reply

TheTimeSavingCo
Forum|alt.badge.img+18

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

Adam, Consultant @ The Time Saving Co
Alec11
1 person likes this
  • Alec11
    Alec11

Reply


Most helpful members this week

Terms & Conditions