Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello every one!
i'm using this set expression to calculate tasks with passed time of completion:
Count({$<[Тип даты]={'*Срок выполнения задачи*'}, [1. День]={"$(=Date(Today(), 'DD.MM.YYYY'))"},[Статус задачи]={0}>}DISTINCT [ID задачи])+ sum({$<[Год]={"*"}>}0)
Highlighted part of expression must response to count only tasks, that have date of completion less than today. but this formula works only with "=" sign. if im using variants like [1. День]<{"$(=Date(Today(), 'DD.MM.YYYY'))"}, or [1. День]={"$(<Date(Today(), 'DD.MM.YYYY'))"}, calculation returns zero, and this is wrong.
So, what the problem?
Try this:
Count({$<[Тип даты]={'*Срок выполнения задачи*'}, [1. День]={"$(='<' & Date(Today(), 'DD.MM.YYYY'))"},[Статус задачи]={0}>}DISTINCT [ID задачи])+ sum({$<[Год]={"*"}>}0)
Try this:
Count({$<[Тип даты]={'*Срок выполнения задачи*'}, [1. День]={"$(='<' & Date(Today(), 'DD.MM.YYYY'))"},[Статус задачи]={0}>}DISTINCT [ID задачи])+ sum({$<[Год]={"*"}>}0)
Mr. Sunny T, cool as always Your formula works. Thanks again.