Zillow Explorer
7 days trial then $30.00/month - No credit card required now
Zillow Explorer
7 days trial then $30.00/month - No credit card required now
💫 Scrape Zillow.com Homes
When downloading recent sales, the "LastSoldDate" comes back as a 13 digit number and Excel doesn't seem to know how to translate it back to a date.
Is it possible to get this to output a useable date? Or something Excel can convert?
Hello, sorry for the inconvenience, it is 13 digit UNIX timestamp (in microsecond)
in excel you can convert to DATE using formula :
= ( TIMESTAMP / 1000 / 86400 ) + DATE(1970,1,1)
Excellent, thank you for getting back to me so quickly.
additional info
the formula also work on google sheet
on javascript/node the formula is :
new Date(TIMESTAMP)
👌cheers
Thank you Cat!
Actor Metrics
16 monthly users
-
7 stars
>99% runs succeeded
3.6 hours response time
Created in Jul 2022
Modified 2 months ago