3 Replies Latest reply: Nov 28, 2014 12:52 PM by Andrew Houston-Floyd RSS

    Create year-based Master Calendar - help

    Andrew Houston-Floyd

      Hi everyone,

       

      I need to create a very simple master calendar, but don't know how. I have two tables, [Systems] and [Platforms]. Systems table has years 2010-2025 in field SystemsYear, while Platforms table has years 2001-2025 in field PlatformYear.

       

      I want to create a new table and field 'Year' for the period 2010-2025 as my master calendar. I do not care about data before 2010. What does the script look like for this?

       

      Thanks!