3 Replies Latest reply on Feb 6, 2015 1:25 PM by philmodjunk

    Recalculate Date Field



      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.