1. Microsoft Learn Documentation: Define calculated columns to automate manual calculations.
Reference: Under the section "Date and Time functions," the documentation lists and describes the ADDWEEKS (increment, date) function, confirming its syntax and purpose to add a specified number of weeks to a date value. It also details other functions like ADDDAYS, DIFFINDAYS, and SUBTRACTDAYS, confirming their respective functionalities and return types.
2. Microsoft Learn Documentation: Formula, calculated, and rollup columns.
Reference: This document explains the different types of columns that perform calculations. The syntax provided in the question (ADDWEEKS, DIFFINDAYS, etc.) is specific to the legacy "calculated columns" feature in Dataverse, which is a core topic for PL-400.
3. Microsoft Learn Documentation: Operators and functions in formula columns in Microsoft Dataverse.
Reference: While this document focuses on the newer Power Fx formula columns, it provides context on date/time manipulation. It highlights the importance of using the correct function (DateAdd in Power Fx) to perform date arithmetic, reinforcing the principle that specific functions like ADDWEEKS are used for specific date operations in other contexts like classic calculated columns.