Skip to content
+1-888-319-3663

COMMUNITY FORUM

how to get sales from the last 3 months based on current date in smartlist builder

bestof Solutions asked 6 years ago
how to get sales from the last 3 months based on current date in smartlist builder
Answers
Best Answer
Jared Dux Staff answered 6 years ago
You would create a calculated field that determines if the sales date is within the last 3 months and then use a restriction to return only the records that are returned as “yes”.  I have included a calculation sample below.
CASE
WHEN {YourTable:YourField} >= convert(date,(DATEADD ( m , -3, GETDATE() ))) THEN ‘yes’
ELSE ‘no’
END

If you would like to submit an answer or comment, please sign in to the eOne portal.