-
1. Re: Date Filter Help
Ivan Young Jun 15, 2016 7:14 PM (in response to Brian Joe)Hi Brian,
I don't think this should be too difficult to do but you will need to keep date in your view although it could be hidden. I'm currently using 9.2 so I can't open your workbook. I should still be able to walk you through the process of building your valid to field which you can use with a param.
1. Build [Valid To]: IFNULL(LOOKUP(MIN([Valid From]),1), TODAY()) - You will not have a value to lookup when you get to the max date for each product so we replace with Today's date
2. Set the Compute for [Valid To]
3. Build your parameter
4. Build your filter: [Between] >= ATTR([TransDate]) AND [Between] < [Valid To]
5. Drag your filter field to filters and set to 'True'
Screenshots of the data before and with a param set to 3/16/2016
Let me know if you have any questions.
Regards,Ivan