🏯 Tweet Scraper V2 (Pay Per Result) - X / Twitter Scraper avatar

🏯 Tweet Scraper V2 (Pay Per Result) - X / Twitter Scraper

Try for free

Pay $0.40 for 1,000 tweets

View all Actors
🏯 Tweet Scraper V2 (Pay Per Result) - X / Twitter Scraper

🏯 Tweet Scraper V2 (Pay Per Result) - X / Twitter Scraper

apidojo/tweet-scraper
Try for free

Pay $0.40 for 1,000 tweets

⚡️ Lightning-fast search, URL, list, and profile scraping, with customizable filters. At $0.30 per 1000 tweets, and 30-80 tweets per second, it is ideal for researchers, entrepreneurs, and businesses! Get comprehensive insights from Twitter (X) now!

GO

Date format isn't UTC compliant

Closed

goldsmif opened this issue
3 days ago

Hi,

I am trying to parse the date in Excel but when I try to use DATEVALUE() in Excel on the string 'Wed Nov 21' it fails. I use other scrapers on this site that don't have this issue, for example the APIFY Instagram scrapers produce valid UTC strings where the date is of the form '2024-11-21' which Excel can parse with DATEVALUE(). I am working with students who can't code and need to process the data in Excel. Can you advise please.

EDIT: run number is 61RPP7dywgiy0JPD0 Thanks,

Andy

apidojo avatar

Hello Andy,

Can you please double check the run ID? I cannot access it https://console.apify.com/view/runs/61RPP7dywgiy0JPD0

Cheers

GO

goldsmif

3 days ago

https://console.apify.com/actors/61RPP7dywgiy0JPD0/input

Also I I rearranged the string so Excel is happy with it using DATEVALUE(CONCAT(MID(G5,9,2)," ",MID(G5,5,3)," ",RIGHT(G5,4))) but it would be a lot easier for my students/me if the date formats were consistent across actors.

Thanks

Andy

apidojo avatar

Hello,

That is not the ID of the run, it is the ID of the actor. Can you please send us the run ID? You can find it under run details page.

Cheers

apidojo avatar

Hello,

Now I got the issue. Unfortunately that is how Twitter returns the date information and our actor provides raw data so there is nothing much to do on our end. But I'm glad you already figured out a workaround!

Let me know if you have more questions.

Cheers

GO

goldsmif

3 days ago

thanks, I do some have another question but not about dates so I'll raise another ticket

Developer
Maintained by Community

Actor Metrics

  • 1.6k monthly users

  • 306 stars

  • 99% runs succeeded

  • 4.3 hours response time

  • Created in Nov 2023

  • Modified 18 hours ago