Home » Categories » Solutions by Business Process » System Features

Additional Forecast Date Options

Datafile Software

Additional Forecast Date Options

Forecast Dates are a database item type that allows you to analyse and ‘manipulate’ date items.Different types of forecast date are available from the basic forecast date where you add/subtract a set number of days from a date field to analysis options telling you the days of the week or the number of days between a base date and today’s date.

Release 6.3 introduces two new forecast options allowing you to analyse the number of weekdays in the month of any given date and the number of weekdays so far within the month. This allows, for example, ProFiler reports to be created showing the average sales value per day in historical months, and the average sales per day for the current month.


When creating a Forecast Date item (Type F) you are asked for the Type of Forecast Date and the Base Date Item to work with plus, for select types a ‘plus’ adjustment value.The new Forecast Date types are:

7 No of Weekdays in Month of Base Date

8 No of Weekdays in Month of Base Date So Far

Note that forecast date type 8 also uses today’s date to determine the number of weekdays so far in the month and if the base date is in a previous month holds the number of weekdays within that month.

Custom Fields
  • Release ID: 6.3
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Ledger Enquiry – Improved Scans Option
Viewed 1125 times since Wed, Jun 13, 2012
Warehouse Tablet - Goods Received Image Capture
Viewed 154 times since Wed, Oct 23, 2024
Landing Pages - Filters – Context Sensitive or Global
Viewed 50 times since Thu, Oct 17, 2024
Additional Options for History / Analysis Enquiries
Viewed 1897 times since Fri, Oct 26, 2012
Ledger Enquiry - Increased No of Stock Location Pick Items
Viewed 163 times since Thu, Oct 17, 2024
Label Printing
Viewed 1947 times since Wed, Jun 13, 2012
Landing Pages - Link to Associate Files for Extra Applications
Viewed 162 times since Wed, Oct 23, 2024
Windows 10 1803 Update / Windows Defender
Viewed 2583 times since Wed, May 30, 2018
User-Definable Ledger Enquiry Applications
Viewed 21848 times since Tue, Jun 12, 2012
Ledger Enquiry Hyperlinks on Application Report Output to Excel
Viewed 10969 times since Mon, Jun 11, 2012