K
KiowaPilot
I track flight time for Aviators, who have minimums to maintain based on
their birthmonth. I am looking to automatically calculate on a report the
ammount of time that they have flown within a 6 month timeframe based on
their b-day, and the current date. For example Aug is my birthmonth and it is
Currently Feb. I would only want to calculate the data between 31 Aug and 1
Mar because todays date of 25 Feb falls between that range. And if todays
date were 3 Mar it would calculate the data between 28 Feb and 1 Sep.
I have two Tables; 1.Pilot Names
name Birthmonth
Joe Aug
Mike Jun
and 2. Flight Data
Date of Flight Name Duty Position Flight Status Time of Flight
3 Feb Joe Instructor Day 2.0
12 Mar Mike Copilot Night 1.5
their birthmonth. I am looking to automatically calculate on a report the
ammount of time that they have flown within a 6 month timeframe based on
their b-day, and the current date. For example Aug is my birthmonth and it is
Currently Feb. I would only want to calculate the data between 31 Aug and 1
Mar because todays date of 25 Feb falls between that range. And if todays
date were 3 Mar it would calculate the data between 28 Feb and 1 Sep.
I have two Tables; 1.Pilot Names
name Birthmonth
Joe Aug
Mike Jun
and 2. Flight Data
Date of Flight Name Duty Position Flight Status Time of Flight
3 Feb Joe Instructor Day 2.0
12 Mar Mike Copilot Night 1.5