SETRANGE DateFormula

idiot · 2009-05-25

What is the syntax to perform SETRANGE for a DateFormula field?
eg SETRANGE for a certain Due Date Calculation for the Payments Terms table

DaveT · 2009-05-25

Hi,

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.

idiot · 2009-05-25

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?

DaveT · 2009-05-25

Hi,

Use a SETFILTER
i.e.

SETFILTER( "Due Date Calculation", '7D' );

idiot · 2009-05-25

Thanks for you help.
Works fine, didn't expect have to use SETFILTER...
But now comes another part

SETFILTER("Due Date Calculation", '<> %1', '7D');

doesn't work

DaveT · 2009-05-25

Hi,

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.

idiot · 2009-05-25

As I suspected, that means there is no direct way to work with SETFILTER/SETRANGE without involving another variable.
Thanks for your help

DaveT · 2009-05-25

Hi,

Yes, I've always used a variable and never invested the time to investigate.

Glad to Help

SETRANGE DateFormula

Comments

Categories