AnsweredAssumed Answered

Date Ranges

Question asked by cosmoqurries on Apr 28, 2009
Latest reply on Apr 28, 2009 by cosmoqurries


Date Ranges


I am new to FM10 - I have been converting databases for our clients, but I am not very fluent in script writing.


I have a database with one table. I want to create a main page that gives users an option to select a season. After clicking on a season, a page would show all the program numbers listed by the selected season air dates. The table is called Table, the two fields that are needed to show are: ShowNumber and AirDate.


The main page will show the following:

Season Three (2008-2009)

Season Two (2007-2008)

Season One (2006-2007)


I can't write the script to successfully pull out the Programs/Shows using data range calculation. Any help would be greatly appreciated.