I have been researching this for a couple of hours now and can't seem to find an answer.
I am using the VizLib Calendar extension (date picker) and the date ranges offered don't meet my needs. If, for example, I wanted the last 3 months of data, what I would get using the built in options would pull a rolling 3-month period.
However, what I'm looking for is a formula that would capture the last 3 months since the 1st of that month. For example, today Sept 11. I need a formula that would grab all dates since June 1st.