--- title: "Last Actual Date" description: "The Last actual date is a model-level setting that represents your latest month (or week if in a weekly model) of \"actual\" historic data. It determines the cut-off date for importing data into your model (unless you have the option 'Import data until' set for a data source)." source_url: https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/working-with-time/last-actual-date language: en last_updated: 2023-08-16 --- # Last Actual Date ## Overview The **Last actual date** is a model-level setting that represents your latest month (or week if in a weekly model) of "actual" historic data. It determines the cut-off date for importing data into your model (unless you have the option 'Import data until' set for a data source). The following applies: - Whenever there is no data present (usually only beyond the **Last actual date**), xP&A will fall back to the formula to determine the value you see in each month. - Charts, trend lines, and time step column headers show forecast periods (beyond the **Last actual date**) as dashed. The [actuals version](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/versioning-a-model.md) includes only months up to and including the **Last actual date**. - There is also a [Helper variable](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-andedit-formulas/helper-variables.md) available for the last actual date. ## Setting the Last Actual Date for the First Time How the last actual date is set for the first time depends on whether you import actual "historic" data via a [data source integration](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data.md) or if you enter them manually: - **If you use data integration**, the **Last actual date** is automatically set when you connect data to a model via an integration for the first time (and the date is in the past). - If you enter data manually, you can determine the Last actual date in the time settings of a model (see [Editing the Model Settings](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/editing-model-settings.md)). ## Updating (Rolling Forward) the Last Actual Date To update the last actual date, i.e. to roll the last actual date forward: {% stepper %} {% stepper-step %} In the **Spreadsheet** view, click **Last actual date** in the column header. {% /stepper-step %} {% stepper-step %} Select the new month using the calendar: {% /stepper-step %} {% stepper-step %} In the dialog that appears, choose: - Which **data sources** you want to refresh (across the current and linked models) - For which **linked models** you want to roll the Last actual date forward. - If you want to save a **version** of the affected models. In this case, the version will be saved as **Latest Oct ‘23** _forecast_ (depending on which month you save it).\ \ {% /stepper-step %} {% stepper-step %} Click **Apply**. {% /stepper-step %} {% /stepper %} {% info-box %} If you roll the Last actual date back in time, any months of data after the last actual date will be cut off. This is useful for instance if you rolled forward but then realized your books were not closed, or the data was not ready yet. {% /info-box %} ## FAQ About the Last Actual Date ### What will happen if I have data beyond the Last actual date in my data sources? Even if you have data beyond the **Last actual date** in your data source, they will not be pulled into your model until you roll the **Last actual date** forward. Nevertheless, a blue dot will be displayed next to the current **Last actual date** to let you know that there is data beyond the **Last actual date**. ### What if I want to bring the forecast months as data from a data source outside of xP&A? For more information on this topic, refer to the [Import Data Until Function.](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/working-with-integrated-data/import-data-until-function.md) ### What if some data items within a model have data up to different points in time? If you are missing months of data for any data items immediately before (and including) the **Last actual date**, xP&A will fall back to the formula for variables connected to those data items for those months. ### Who can change the last actual date? Anyone who has full or edit access to the model. ### What happens if I refresh data but did not do so via the Last actual date header? (e.g. via auto-refresh, or directly on the data source) - If you refreshed and there is now data present beyond the current **Last actual date**, a blue dot will be displayed next to the current **Last actual date** to let you know there is data available. Once you update the **Last actual date**, the new data will be pulled into the model(s). - If you refreshed and data changed for any historic months (up to and including the **Last actual date**), this data will be reflected immediately in the model(s). ### What happens if I’ve updated my Last actual date but my data source(s) takes a while to refresh? - Most data sources refresh within 1-2 minutes. However, some larger data sources may take longer. In these instances, you may have a new **Last actual date**, but no data being pulled in for it yet. A moving refresh icon will be displayed in the header next to the new **Last actual date** in any model connected to a refreshing data source. - If you know your data sources take a while to refresh, you could instead refresh the data source first, and then update the **Last actual date** once the refresh is finished. ### What if I want to restrict months of data, but just for one data source (not all) in a model? For more information on this topic, refer to [Import Data Until Function.](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/working-with-integrated-data/import-data-until-function.md) ### What if I don’t use the Last actual date at all? No worries! Data will flow into the model(s) to which they are connected to as and when they are refreshed, up to whatever months or time steps the data source has data for. Note that there will be no automatic visual distinction between historic months in time step headers or charts, and you will not be able to use the [Last Actual helper variable](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-andedit-formulas/helper-variables.md) or [Actuals version](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/versioning-a-model.md).