Range

HCL Domino Domino Forum
1

a:= 20b:= 1 to 50

Do you have formula language code to determine if the value of field a is in tha range of field b?

2

Subject: Range

do you need to have b like that or could you have

a:= 20;

b:=1;

c:=50;

range :=@If((a => b) & (a <= c) ; “Yes” ; “No”);

@Prompt([OK];“In Range”;range)

3

Subject: RE: Range

if designing the form better as Cath suggests is not an option, you could have

b_lower := @tonumber(@trim(@left(@text(b); “to”)));

b_upper := @tonumber(@trim(@right(@text(b); “to”)));