I have a form called Employee with the following fields.
TotalDays Number Computed
Due:=@Abs(@Integer((HireDate -ToDate) / (60 * 60 * 24)));
I have created some documents and TotalDays works fine. Returns 1 if HireDate is 04/10/2004
I've created a view for Employee form. View is called Employee View | EMPV.
In the view, I've created columns for all the 4 fields. If I create a document, the view displays Empno, Name, HireDate but does not display the TotalDays. I struggled for a long time but couldn't get the solution. :(
Actually I need this view when an employee completes 1 month. Means when 30 appears in the TotalDays of the view, an agent triggers a notification to someone.
Or anyone has any other way to send a notification if the totaldays is 30. ??