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
Search property data from Zillow.com
Last Sold date not Working
Closed
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!
cat- 18 monthly users
- 98.0% runs succeeded
- 7.4 days response time
- Created in Jul 2022
- Modified 4 months ago
