Auto populate dates

No problem,

I suggest creating a table of School Terms.  That table will hold your drop down choices for the School Terms.  If this is a new app with no data yet, then I suggest leaving the Key field of that table being the Record ID. If you have a lot of data, too much to Grid edit then post back and we can deal with that.

The fields on the table will be
Term Name (text field)
Start date (date field)
and the rest of the fields will be formula date fields.

The formula to adjust a date to a different month is

AdjustMonth([Start Date], -1)

for example that would make a date calculate to 1 month before the start date.

Then you will make a relationship where 1 School Term has many Courses, and then lookup all those data fields down into your Courses record.

Post back if you have any questions.


 

Thank you! How would I adjust the date by two weeks? The copy date field should be -2 weeks from the start date. I tried .5 but that didn't seem to work. 

[start date] - weeks(2)

or also you can do

[start date] - days(14)

Thank you- I am gettting a syntax error for both..? This is my formula based on the field of Term Start Date.
AdjustMonth([Term Start Date],- weeks(2)  

The AdjustMonth function is only used to adjust dates in whole integer month increments.  There is a specials function for that as well as another one AdjustYear, as not all months and years are the same length.

But to adjust by a certain number of days, you do not use the Adjust Month function at all, so just use what I suggested above

[start date] - weeks(2)

Ah- sorry I wasn't clear I had to wipe out the existing formula and replace it. Sorry about that, now it works perfectly. :)