Imagine this scenario,
I've calculated the average number of days that a Purchase Order takes to get in the wharehouse. Basically the difference between the Posting Date and the Order Date . The result was a value integer.
My goal is to fill in the table Item , the field Safety Lead Time that is a date formula, but it need a preefix such as D or it gives me back error.
How can i converto the integer to days?
This is what i've tried
MediaDias:=ROUND((DiasTotal/ContadorDocs),1,'>');
EVALUATE(DataP,FORMAT(MEdiaDias));
Item."Safety Lead Time Calculado":=DataP;
Item.MODIFY;
Where DataP is also datatype Dateformula.
Thanks for the help
Answers
EVALUATE(Item."Safety Lead Time Calculado", FORMAT(MEdiaDias) + 'D');
Item.MODIFY;
Thanks anyway!