Convert value integer to DateFormula

(0) Share

Report

Posted on by Rikarddo

265

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

*This post is locked for comments

All responses (3)

Answers (1)

Suggested answer

Rikarddo 265 on at

Like (1)

Report

RE: Convert value integer to DateFormula

Thanks! It was a big help!
Suggested answer

Rikarddo 265 on at

Like (0)

Report

RE: Convert value integer to DateFormula

Got it..

EVALUATE(Item."Safety Lead Time Calculado", FORMAT(MEdiaDias) + 'D');

Item.MODIFY;

Thanks anyway!
Verified answer

Hannes Holst 5,767 on at

Like (1)

Report
RE: Convert value integer to DateFormula

MediaDias:=ROUND((DiasTotal/ContadorDocs),1,'>'); EVALUATE(DataP,'<'+FORMAT(MEdiaDias)+'D>');

There are probably better solutions somewhere :-)