Greater than date in set analysis

[#1]

Hi,

We have the following expression:

=count({<[MonthYear2]={">=$(vPreviousMonth4.))"}>}TaskId)

This doesnt work.

The variable is as following:

Let vPreviousMonth4. = text(date(addmonths(date(Now()),-4),'M-YYYY'));

When we write the expression as the following:

=count({<[MonthYear2]={"$(vPreviousMonth4.))"}>}TaskId), it shows us all of Nov 15 only. However when we say greater than, it shows nothing.

Help please.

Thanks.

[sunny_talwar · Accepted solution]

Is MonthYear2 a text field? You are using text in your variable, so I am guessing MonthYear2 is text. If it truely is text field, then I am not sure how are you hoping to find greater or less than of a text field?

[hic]

I think you have a bracket too much.

  count({<[MonthYear2]={"$(vPreviousMonth4.))"}>}TaskId)

See also Dates in Set Analysis

HIC

[Anonymous]

I  agree  with Henric Cronström,  your  expression have  one  bracket  of more.

=count({<[MonthYear2]={">=$(vPreviousMonth4.)"}>}TaskId)

Regards

[engishfaque]

Dear Sharandeep,

This expression is working fine to me,

=Count({<[MonthYear2]={">=$(vPreviousMonth4.)"}>}TaskId)

Kind regards,

Ishfaque Ahmed

[#6]

Very true. Thank you