1 of 1 people found this helpful
It appears that yesterday is going to be the latest date in your dataset. In which case instead of basing your DATEDIFF on today you could base it on yesterday, which should solve your problem. For example:
If [Date Notified] <= TODAY()
And DATEDIFF('month',[Date Notified],DATEADD('day',-1,TODAY())) = 0
Interested to hear if that modification fixes this for you. If so you can modify YTD in the same way.
That seem very logical, I'll give it a go and will find out if it works on the 1st.