Aggregate function to get all days in certain month?

Aggregate function to get all days in certain month?

Greetings

I need a way or an aggregate function that would return all days in a certain month to show them in my report, is there such a way/function? i tried searching through date functions but couldn't find what i'm looking for.

Thanks