🏯 Tweet Scraper V2 ($0.4 / 1K tweets) - X / Twitter Scraper
Pricing
from $0.40 / 1,000 tweets
🏯 Tweet Scraper V2 ($0.4 / 1K tweets) - X / Twitter Scraper
⚡️ Lightning-fast search, URL, list, and profile scraping, with customizable filters. At $0.40 per 1000 tweets, and 30-80 tweets per second, it is ideal for researchers, entrepreneurs, and businesses! Get comprehensive insights from Twitter (X) now!
2.3 (75)
Pricing
from $0.40 / 1,000 tweets
735
Total users
18K
Monthly users
2.3K
Runs succeeded
>99%
Issues response
5.2 hours
Last modified
a day ago
Date format isn't UTC compliant
Closed
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
Hello Andy,
Can you please double check the run ID? I cannot access it https://console.apify.com/view/runs/61RPP7dywgiy0JPD0
Cheers
goldsmif
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
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
goldsmif
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
goldsmif
thanks, I do some have another question but not about dates so I'll raise another ticket
