Payment Terms code to Date Formula

gemini_shooter

Hello All,

How can I convert a code variable into Date, so I can use it in CalcDate function.

I tried the following on the custom variable

PaymentTerms := "Payment Terms Code";

varDate := CALCDATE(PaymentTerms, CustLedgerEntry."Posting Date");

also tried

varDate := CALCDATE(CALCDATE(PaymentTerms), CustLedgerEntry."Posting Date");

I am also checking for a blank date so my IF statement is

IF varDate = 0D THEN ....... is that comparison correct; if not how else do u check for a blank in date variable in a report ?

David_Singleton

just use EVALUATE.

gemini_shooter

Thank you David

David_Singleton

:thumbsup: