This filter should do it. Set the [as_of_date] to the required date ( e.g. current_date )
[Date] between _first_of_month ( [as_of_date]) and (_add_days ([as_of_date],-1) )
------------------------------
Andrei Istomine
Open to work - anything Cognos
https://www.linkedin.com/in/andreii/------------------------------