I have a master calandar that is tied to Straight Table with multiple different dates.
Purchase Date Shipped Date Invoice Date
01/11/2007 01/11/2007 20/01/2008
01/08/2007 01/09/2007 22/09/2007
05/10/2009 05/14/2009 20/02/2010
01/06/2010 01/06/2010 20/12/2010
Requirement:
1) When i select Month and Year on Calander (which is created with all the dates combined from above 3 dates).I want the straight table to only show range of dates within that selected time period.
I'm not sure why your solution isn't already working, although I think you'd be better off switching your data model around and creating a single date field on the sales table. Can you post your app?
