December 7th: Month to yesterday - on the first day of month

Very often, people get it wrong when they try to modify a 'Month to date' dynamic criteria to a 'Month to yesterday' dynamic criteria.

The result, on the 1st day of a month, will usually end up in something like this:


Furthermore, the same problem may apply to situations like 'Year to yesterday' and 'Week to yesterday'.

Watch the video for a solution to this common issue. You may also read this article for further details:

Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.