How force function AddMonths work?

[#1]

Hi to all!

I have field with Date, and in SET ANALYSIS i need Date bigger at 1 month.

But AddMonths Does not work...

Look in attach.

[Gysbert_Wassenaar]

In a text box you can use =AddMonths(CurrDate,1) if you first select one value in the field CurrDate.

[#3]

Do not use Dollar expansion in text object, use it Like =Addmonths(CurrDate,1)

[#4]

yes, i know.

but i use AddMonths in SET ANALYSIS, and there $(=AddMonths(CurrDate,1)) does not work, because this function doesn't result a date.

and a textboxes i add for clarity.

[#5]

yes, look my answer above

[#6]

Привет!

CurrDate - это поле, Set Analysis не принимает поле, как правую часть условия, ему нужно конкретное значение. Попробуй использовать функцию p():

$(=AddMonths(p(CurrDate),1))

[Gysbert_Wassenaar]

Because your field CurrDate doesn't contain any value that's exactly a month later than another value. If you add such a value you can see that addmonths does work. See attached qvw.

[#8 · Accepted solution]

use dis in set CurrDate ={'$(=AddMonths(CurrDate,1))'}

[#9]

Он прекрасно принимает поля. когда в них выбрано одно значение. Если не выбрано ничего или выбрано несколько то конечно ничего работать не будет.

[#10]

Thank You, i just forgot to put quotes in textbox

If in TX08 put text "='$(=AddMonths(CurrDate,1))'" - all works perfectly!