"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