AnsweredAssumed Answered

Recalculate Date Field

Question asked by KeithEason on Feb 5, 2015
Latest reply on Feb 6, 2015 by philmodjunk


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.