Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
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?
I think you have a bracket too much.
count({<[MonthYear2]={"$(vPreviousMonth4.))"}>}TaskId)
See also Dates in Set Analysis
HIC
I agree with Henric Cronström, your expression have one bracket of more.
=count({<[MonthYear2]={">=$(vPreviousMonth4.)"}>}TaskId)
Regards
Dear Sharandeep,
This expression is working fine to me,
=Count({<[MonthYear2]={">=$(vPreviousMonth4.)"}>}TaskId)
Kind regards,
Ishfaque Ahmed
Very true. Thank you