I hope you are all well.
I need some help with dates, i feel as though that's always the biggest pain points.
Problem: The exec's would like to see sales calendar year and that is defined as November 30th 2016 to Dec 31th 2017
The view has the dates rounded to the first of the month in the view i am bringing in.. so if transactions occurred on any date within that month it rounds to the 1st and displays the first.
I'd like to have a variable set as '2016-11-30' to '2017-12-31'
How do i set a variable to a specifically go to those dates?