Sorting Date/Time when Different Time Zones
Posted on 2013-06-28
I have an internet application written in classic asp that records flight information and I need to be able to print out the itinerary in date/time order properly. If I have someone leaving from NY and flying to Australia, on the return flight, I need to see them in proper order. I could have the user enter the timezone as necessary, but then I'm needing to know how to properly sort these. I have a few instances where the first return flight has a later time (in that time zone) than the second flight in its current time zone. This is not ordered properly and I need assistance in how to get them entered so that I can sort properly.
Hard to put it into words, so I'm hoping someone can help.