Recalculate Date Field
I have StartDate and EndDate fields in a portal that are set up as Date fields. I use the
GetNthRecord (DatesClosed::Date ; Student::TotalDaysAssigned )
to search a table of open and closed dates to get the EndDate. It works great, but when I change the TotalDaysAssigned field on the Layout, it will not update the EndDate until I re-enter the StartDate. The StatDate is a PullDown Drop List for the Calendar.
How can I get it to update the EndDate when I change the TotalDaysAssigned automatically?
I have tried Commit and refresh to no avail.
I appreciate any help I can get.