Description |
* Season Reset will be obsoleted as well as the 3 YTD Gallons and 3 YTD Dollar fields.
** Remove YTD fields from tblTMSite database
* Need to calculate 3 year Delivery Summary by Site at run time and to be based on actual Calendar Years and delivery history.
** Current Year = Summer Start Date of Current Year to Current System Date
** Prior Year = Summer Start Date - 1 Year to Summer Start Date - 1 day
** 2 Years Ago = Summer Start Date - 2 Years to Summer Start Date - 1 year - 1 day
** Example 1
*** Summer Start May
*** System Date December 15th, 2016
*** Current Year = 5/1/2016 to 12/15/2016
*** Prior Year = 5/1/2015 to 4/30/2016
*** 2 Years Ago = 5/1/2014 to 4/30/2015
** Example 2
*** Summer Start May
*** System Date February 15th, 2017
*** Current Year = 5/1/2016 to 2/15/2017
*** Prior Year = 5/1/2015 to 4/31/2016
*** 2 Years Ago = 5/1/2014 to 4/31/2015
* Applies to:
** Efficiency Report
** Site > Details Tab
** Budget
|