
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
Last Sold date not Working
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)
NoUturns
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
NoUturns
Thank you Cat!
Actor Metrics
21 monthly users
-
9 bookmarks
99% runs succeeded
60 days response time
Created in Jul 2022
Modified 4 months ago