The calculated distance (air line) between Colonie and New York City is approximately 139 miles respectively 223 kilometers.
By car or train, the actual journey to New York City is certainly longer, as only the direct route (as the crow flies) between Colonie and New York City has been calculated here.
Air line (approximately)
223 kilometers
120 nautical miles