This content has been marked as final.
Show 5 replies
-
1. Re: Date filter to only include dates thru previous month
Vinnie Ahuja Dec 15, 2017 11:53 AM (in response to Alysse Mea)1 of 1 people found this helpfulI think what you have is close, try this:
if DATETRUNC('month', [DATE]) < DATETRUNC('month', TODAY())
then "Prior Month"
else "This Month"
End
You could leave "Prior Month" in the filter and exclude "This month"
-
2. Re: Date filter to only include dates thru previous month
Vinnie Ahuja Dec 15, 2017 11:55 AM (in response to Vinnie Ahuja)1 of 1 people found this helpfulOh wait...I see you are doing this for LAST YEAR. Hang on...I will update.
-
3. Re: Date filter to only include dates thru previous month
Vinnie Ahuja Dec 15, 2017 11:59 AM (in response to Vinnie Ahuja)1 of 1 people found this helpfulOK, try this...this will give you a boolean. You can add to the filter shelf and exclude "FALSE".
YEAR([DATE]) < YEAR(today())
and
DATETRUNC('month', [DATE]) < DATETRUNC('month', DATEADD('year',-1,today()))
-
4. Re: Date filter to only include dates thru previous month
Alysse Mea Dec 15, 2017 12:28 PM (in response to Vinnie Ahuja)This formula worked! Thanks, Vinnie!
-
5. Re: Date filter to only include dates thru previous month
Vinnie Ahuja Dec 15, 2017 12:33 PM (in response to Alysse Mea)Awesome!!! You are welcome!!