Integer Value to Date Formula

Rikarddo
Rikarddo Member Posts: 80
in NAV Three Tier
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

Best Answer

  • Rikarddo
    Rikarddo Member Posts: 80
    Answer ✓
    Got it..

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

    Thanks anyway!

Answers

  • Rikarddo
    Rikarddo Member Posts: 80
    Answer ✓
    Got it..

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

    Thanks anyway!

Categories