Dynamic Date Issue

[mabbio]

Hello,

When trying to do a Month To Date report i am using Date Entered= to Current Month however, when there is a start to a new month, i do not get the total ofr the previous month its auto rolls into the next month. I.E. on 12/1 i would like to see the totals for 11/1-11/30. Is there a way to complete this so that when the report is published to the Services i dont have to manually adjust every month. 

TIA.

[v-cazheng-msft]

Hi @mabbio 

Could you please provie some sample data or screenshots to make your issue more clear? 

Best Regards,

Community Support Team _Caiyun

[mabbio]

When I use this Relative Date its fine 12/1-12/31 but when the month switches on 1/1 it will restart the month but i would like to full month of December. This is a daily report with a MTD View so i just need that one day.