Can dates be fixed in OfficeConnect?
Absolute dates allow you to build a report with periods that are not impacted by a change of the report date.
Yes, time periods can be fixed in OfficeConnect. In Workbook Properties, disable the "Make new time elements relative to the report date" property. From this point forward, any time periods added to the report will be fixed and will not adjust when the report date changes.
You can also change an existing time period to absolute.
Watch the video below to learn more about absolute dates in OfficeConnect.