Updating date

Hanen_T · 2011-10-04

Hello,

How can I keep a field date uptodate. My field is a result of calcdate(Lead Time Calculation,workdate);
I want to have at anytime the right value on this field.

Thank you #-o

mohana_cse06 · 2011-10-04

Try by adding the below code in Item Card Form - OnAfterGetRecord() and Item Table Lead Time Calculation - OnValidate() triggers

Uptodate := CALCDATE("Lead Time Calculation",WORKDATE);

Uptodate is a Date type field in Item table

David_Singleton · 2011-10-04

mohana_cse06 wrote:
Try by adding the below code in Item Card Form - OnAfterGetRecord() and Item Table Lead Time Calculation - OnValidate() triggers
Uptodate := CALCDATE("Lead Time Calculation",WORKDATE);
Uptodate is a Date type field in Item table

Simpler is just to add this as the source expression of the control. The problem is that if you get an error you wont be able to then open the form.

mohana_cse06 · 2011-10-04

David Singleton wrote:
mohana_cse06 wrote:
Try by adding the below code in Item Card Form - OnAfterGetRecord() and Item Table Lead Time Calculation - OnValidate() triggers
Uptodate := CALCDATE("Lead Time Calculation",WORKDATE);
Uptodate is a Date type field in Item table
Simpler is just to add this as the source expression of the control. The problem is that if you get an error you wont be able to then open the form.

You are right.. :thumbsup:
and we dont need a new field also

Hanen_T · 2011-10-04

Thank you but just one more thing where will I put this Uptodate := CALCDATE("Lead Time Calculation",WORKDATE); on which trigger???
I will need this field to calculate a new field copy of invetory but wher the posting date is < my new field (Uptodate := CALCDATE("Lead Time Calculation",WORKDATE));

Hanen_T · 2011-10-04

It didn't work, I have the right value on the form and not on the item table :oops:

vaprog · 2011-10-04

If you want it in the Iten table then create a function in the table object and use it as it it was a read only field.
You cannot keep a real database field current. You can approximate "current" by running batch jobs, or make it current by using a function.

Updating date

Comments

Categories