Calculate distance (in Miles) between two zip codes

You can download free excels dumps of every zip code
http://federalgovernmentzipcodes.us/

That will allow you to geocode your zips.

Then you can wake up sleeping Pythagoras from 2,500 year ago who will answer your question.

// In the USA, the typical distance between integer Longitude lines is about 53 miles. (these are the east / west coordinate)   
// They are further apart at the equator (69 miles) and approach zero at the North Pole.
// but we have few courses at the north pole or the equator, so lets just call it 53.   
// In the whole world, its 69 miles between integer Latitude lines.

// With credit to Pythagoras, we know that for a right angle triangle A^2 + B^2 = C^2.  I will use (A^2 for A squared) 
// We want to find the length of the C diagonal where A is the North South distance and B is the West East Distance
// Let LA1 be the LAtitude 1
// Let LO1 be the LOngitude 2
// Let LA2 be the LAtitude 1
// Let LA2 be the LOngitude 2


// So C^2= A^2 + B^2
// C = SQRT (A^2 + B^2)
// C = SQRT ((69*(LA1-LA2))^2 + (53*(LO1-LO2))^2)
// note that to take a square root you raise it to the power of 1/2 or 0.5

var number OriginLat    = [Patient Zip Code - Latitude];
var number OriginLong = [Patient Zip Code - Longitude];
var number DestLat      = [Consultant Zip Code - Latitude];
var number DestLong   = [Consultant Zip Code - Longitude];


var number Distance =
Round(
((69*($OriginLat - $DestLat))^2 + (53*($OriginLong - $DestLong))^2)^0.5
);

If($OriginLat =0 or $DestLat=0,0,$Distance)

Mark- 

Thank you that worked great!