1 of 1 people found this helpful
Please check this:
You can of course get the start of the month with:
DATETRUNC('month', <your date>)
And the last day of the month with:
DATEADD('day', -1, DATETRUNC('month', DATEADD('month', 1, <your date>)))
Note, I did also just test your calculated field that was returning 1 for you, but it returned 30 for me. Are you sure that is the version that was giving you 1?
The link didn't help me because it only calculates finished months, not future months.
I did, however, select "Maximum" on the drop-down list of my original calculation, which now comes out to 30 (the correct number of days in June) but now I have to remove the weekends and possible holidays.
Sorry, you did not specify that in your original post. You should still be able to employ the logic the article uses in your calculation instead of trying to re-create the wheel.
If you need something to calculate for the future, consider extending the end date to reflect that. If that does not work, can always include X number of blank records in your datasource for future months you need. Doing that would be very simple and it would be simple to filter out from other views as well.