Flights that Cross Midnight

"Peter Duniho" wrote in message
...
"ydm9" wrote in message
om...
[...]
Their current function always gets the GMT based on the effective date
of the flight. This is fine for 99% of the time. When a flight
crosses midnight and it's around time change dates, the effective date
of the flight might need to have a day added to it if the flight
crossed over midnight.

Any input or direction would be greatly appreciated.

I think your employers should hire a better programmer.

If you think the problem you're working on now is hard, wait until you
have
to deal with a flight that crosses the International Date Line. I'm
guessing your head will explode.

That crosses the Date Line overnight. The LA-Auckland flights leave in the
evening and arrive in the morning 2 days later. The return flights leave in
the evening and arrive that same morning.

-- David Brooks

I recall looking at a flight schedule some years ago for a local carrier in
the Samoa area, I believe. They had a late-night inter-island flight that
arrived the day before it departed.


"David Brooks" wrote in message
If you think the problem you're working on now is hard, wait until you
have
to deal with a flight that crosses the International Date Line. I'm
guessing your head will explode.

That crosses the Date Line overnight. The LA-Auckland flights leave in the
evening and arrive in the morning 2 days later. The return flights leave
in
the evening and arrive that same morning.

-- David Brooks

They had a late-night inter-island flight that
arrived the day before it departed.

Humberto Ecco spun this conceit into a fat novel called The Island of
the Day Before.

It wasn't very goodl.

all the best -- Dan Ford
email: (put Cubdriver in subject line)

The Warbird's Forum www.warbirdforum.com
The Piper Cub Forum www.pipercubforum.com
Viva Bush! blog www.vivabush.org

You could fairly easily do that within the continental US.

-- David Brooks

"John Gaquin" wrote in message
...
I recall looking at a flight schedule some years ago for a local carrier
in
the Samoa area, I believe. They had a late-night inter-island flight that
arrived the day before it departed.


"David Brooks" wrote in message
If you think the problem you're working on now is hard, wait until you
have
to deal with a flight that crosses the International Date Line. I'm
guessing your head will explode.

That crosses the Date Line overnight. The LA-Auckland flights leave in
the
evening and arrive in the morning 2 days later. The return flights leave
in
the evening and arrive that same morning.

-- David Brooks

"David Brooks" wrote in message
news:409ac165

You could fairly easily do that within the continental US.

Technically, yes. I suppose I should have been more precise. This flight
arrived not just "the day before" it departed, but [almost] "a" day before.
IIRC it was about a 30 min flight that arrived about 22 or 23 hours before
it departed.



"John Gaquin" wrote in message
...
I recall looking at a flight schedule some years ago for a local carrier
in
the Samoa area, I believe. They had a late-night inter-island flight
that
arrived the day before it departed.