Create Post Schedule Task to Write Mining Dates into Deposit Table

In order to report on the Mining Dates, you would need to create a 'Post Schedule Task' that writes back the start and end dates of a solid back into the deposit table. Once the dates are recorded in the deposit table you could then use these in the filter expression when creating the ranges.

 
In order to write the dates back, you will need to create new date fields in your deposit table, eg:
 


 
Once these dates fields are created you would then need to setup the post schedule tasks (in Scenario settings) to write the Start and End Dates back for each record, this would look something like this:
 


 
After the Post Schedule Task has been setup, whenever you run your schedule the start and end dates of each record will be updated in the Deposit Table.
 

 

Creating a Range of Completed Records withing a Date Period:

Once the dates are written to the deposit table you can create a range and use the following filter expression to find the records that have been completed between your desired date range:
 

 
Expression:
Between(GetValue(PostScheduleTaskMiningDatesEndDate),#1 Jan 2026#, #1 July 2026#)

Want to learn more?

Online Help Manuals - Click here for the latest version

Learning Management System - Click here to login or here to request access