Filter for current month minus current day

[andy.rock]

Hello...I am new so I hope this is the rigt spot to post. I am trying to filter the below to current month minus the current day but I cannot figure it out. Hoping somoene can help.

[Sales].[Invoice Established Date].[Actual Date]

I am new to these report builds so any help or advice would be greatly appreciated.

Thanks!

[cognostechie]

You probably don't have current day's data in your Data Warehouse anyway so use this as the filter:

[Sales].[Invoice Established Date].[Actual Date] >= _first_of_month ( current_date )

If you have current day's data then use this:

[Sales].[Invoice Established Date].[Actual Date] >= _first_of_month ( current_date )  and
[Sales].[Invoice Established Date].[Actual Date] < current_date

In the report, when you open a data item, there are functions available on the left pane. Look for data/time functions.

[andy.rock]

You are right on current day. I just used the first function you provided and it is doing exactly what I needed. Thanks for your help!