"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.

Pete