Payment Terms table
I want to retrieve all records where the Due Date Calculation is 7D through code. (7D is not a constant but is the eg value).
Can it be done without involving EVALUATE?
NAV - Norton Anti Virus
ERP Consultant (not just Navision) & Navision challenger
Comments
Not sure what you what to acheive. A DateFormula is string used to increment/descrement a date. Would a FlowFilter e.g. "Date Filter" not suit better.
Can you give an example of what you want to do.
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
I want to retrieve all records where the Due Date Calculation is 7D through code. (7D is not a constant but is the eg value).
Can it be done without involving EVALUATE?
ERP Consultant (not just Navision) & Navision challenger
Use a SETFILTER
i.e.
SETFILTER( "Due Date Calculation", '7D' );
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
Works fine, didn't expect have to use SETFILTER...
But now comes another part doesn't work
ERP Consultant (not just Navision) & Navision challenger
I'm assuming that this is giving a compile error. two options:
use
MyStr := '<>7D';
SETFILTER( "Due Date Calculation", MyStr );
and generate the '<>7D' using a string variable STRSUBSTNO etc.
use
EVALUATE( MyDateFormula, '7D' );
SETFILTER("Due Date Calculation", '<> %1', MyDateFormula );
and generate the '7D' with the EVALUATE command.
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
Thanks for your help
ERP Consultant (not just Navision) & Navision challenger
Yes, I've always used a variable and never invested the time to investigate.
Glad to Help
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html