Hi team, I have created Total cases for the Current MTD , Current QTD and Current YTD. The data shows correctly However, when I create previous MTD, previous QTD and previous YTD. The data are a...
It is a best practice to use a separate dates table and not auto datetime. Also, when you say previous MTD is that relative to the current date in the current month. For example if today is Aug 9 is the calcultion for July up to the 9th or the whole month?
