Convert value integer to DateFormula

(0) Share

Report

Posted on by Rikarddo

273

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

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Hannes Holst 5,767 on at

Like (1)

Report
Copy link

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

There are probably better solutions somewhere :-)

Was this reply helpful? Yes No
Suggested answer

Rikarddo 273 on at

Like (0)

Report
Copy link

Link copied!

Got it..

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

Item.MODIFY;

Thanks anyway!

Was this reply helpful? Yes No
Suggested answer

Rikarddo 273 on at

Like (1)

Report
Copy link

Link copied!

Thanks! It was a big help!

Was this reply helpful? Yes No