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: https://community.targit.com/hc/en-us/articles/4417199662225-Month-to-yesterday-at-first-day-of-month
Please sign in to leave a comment.