Sometimes you might want to calculate the difference between 2 dates - or maybe the difference between today and a certain date.
The data source could look something like this:
Now we want to calculate the difference between expected and actual dates.
First we add the data source, right click it and choose to create a format:
Now we add a new column by clicking the + sign in the upper right corner:
We define the new column like this - use the formula durationdays and make sure the destination type is integer:
Now we have a new column that shows the difference between these days in the column difference.