Weekly truncations

Often, business reports are run on a weekly to monthly basis with a set date pattern (e.g. run on the Monday of every week).

However, there can be times where a faulty date is added to the report due to human error or some other cause.

How might we correct this? Through the usage of DATETRUNC(). Let's see how we can identify these changes!

If you lost progress, load the workbook 2_2_date_truncation_weekly.twbx from the Workbooks folder on the Desktop.