I have a table with Date and Flight times. I need a calculation field to show me all flight time for the last 30 days 90 days and 120 days. Preferably this would always stay current based on current date. Thanks in advance.
Example
11/8/2017 2.4
1/1/2018 1.5
1/2/2018 2.1
Last 30 days 3.6
There are multiple ways to do this. Some methods might use a script or relationship to Find or match to records in the specified range.
This method does not, but requires unstored calculation fields:
if ( dateField >= ( Get ( CurrentDate ) - 30 ) ; FlightTime )
A Summary Field can then compute the total of this unstored calculation field if your found set has at least the records from the last 30 Days.
Note that a summary field that totals the flight time field can also give you this figure if you first perform a Find for flights in the last 30, 60, or 90 Days.
ExcecuteSQL could also compute such totals and this method does not require a found set.