Share
Report
21Hi all,
I have a doubt regarding date Formula, I have two field One Is date Field , Another one is Dateformula Field ,
here how to add or (Sum) these field & Store another One variable..
i have write code , Its Doesn't Work ...
Correct by code ...
Kindly help me ..
saleshdr.RESET;
saleshdr.SETRANGE("No.",SLine."Document No.");
IF saleshdr.FINDSET() THEN BEGIN
REPEAT
recItem.RESET;
recItem.SETRANGE("No.",SLine."No."); // ETDdate := dateformula field.. & First approval Date := date field ..
IF recItem.FINDSET() THEN BEGIN
ETDdate := recItem."Lead Time Calculation";
Sline.ETD := CALCDATE(saleshdr."First approval date", ETDdate);
SLine.MODIFY;
END;
UNTIL SLine.NEXT = 0;
END;
saleshdr.SETRANGE("No.",SLine."Document No.");
IF saleshdr.FINDSET() THEN BEGIN
REPEAT
recItem.RESET;
recItem.SETRANGE("No.",SLine."No."); // ETDdate := dateformula field.. & First approval Date := date field ..
IF recItem.FINDSET() THEN BEGIN
ETDdate := recItem."Lead Time Calculation";
Sline.ETD := CALCDATE(saleshdr."First approval date", ETDdate);
SLine.MODIFY;
END;
UNTIL SLine.NEXT = 0;
END;
Categories:
All responses (
Answers (
