AnsweredAssumed Answered

searching with dates

Question asked by njoyce on Sep 3, 2009
Latest reply on Sep 10, 2009 by njoyce


searching with dates




 I have a database of studies and the date that they have been submitted (among other data points).  I want to create a report that has information on studies submitted within a specified time period. So, for example, I want the user to click on a button which then brings them to a search page and have them enter in the time frame.  Ideally, I would like it be so that they enter in a date and filemaker creates the report using studies submitted since this date, however, I have also created a time interval field (date_submitted - get(current date)), so that if that's not possible they can enter in a number of days (e.g. the past 90 days).  Is there a way to do this (either option?)