I am not sure whether it is an optimized calculation however, if you create the following calculated field and drag it to the filter and choose 'True' then you will get the desired output
Date('1900-' + Str(Month([Order Date])) + '-' + Str(Day([Order Date])))>=#1900-Aug-15#
Date('1900-' + Str(Month([Order Date])) + '-' + Str(Day([Order Date])))<=#1900-Oct-15#
DateFilter Sample.twbx.zip 947.1 KB
This worked, thank you.
Another question maybe you can help me with. I want to compare sales data year to date for last year and this year. How do I get it to limit last years data to the 15th of October without manually deselecting the rest of October from last year in a filter.
Is there a way to do it so it will automatically limit last years data to whatever date we are up to for this year?