https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/115954.aspxFri, 31 Mar 2017 16:52:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115954K5Optima0https://www.infopathdev.com:443/forums/thread/115954.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115954Thanks Hilary, that's what I thought. I did end up filtering on the date range. I had to get creative though because the item has a Due Date but it's recurring, so what I ended up doing was creating SP Workflows to update the next due date based on if it was monthly - advance it 1 month, annually - advance it 1 year, 3 years - advance 3 years etc. Then I set it up using a Information Management Policy and enabling Retention to kick off the workflow recurring. This way the dashboard will accurately display info as the dates change.https://www.infopathdev.com:443/forums/thread/115953.aspxFri, 31 Mar 2017 16:07:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115953Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/115953.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115953Calculating the number of months is not easy - there are some complex calcs you can find online for doing this sort of thing in IP - I'm not math-y and actually am more likely to just write code for it. HOWEVER - hiding rows in a date range is easy - see attached sample. You can save the file locally, right click and preview. I've got some default data in there so you can just set a start & end and see the filtered results. :)https://www.infopathdev.com:443/forums/thread/115948.aspxThu, 30 Mar 2017 17:32:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115948K5Optima0https://www.infopathdev.com:443/forums/thread/115948.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115948Hoping for some suggestions on how to accomplish this. I have two date fields that I want to calculate the number of months between the two and then show data that falls between that time.