Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am using following set analysis to count contracts:
='Contracts: ' & (Count({1<
Status={'Active'},
ContractEndDate={"=ContractEndDate>=Date(MonthsStart(1,Today(),1)) and ContractEndDate<=Date(MonthsEnd(1,Today(),1))"}
>}Distinct OrganisationID))
I want to ignore user-selections, therefore I used the identifier 1, but I think this does not work for the part:
ContractEndDate={"=ContractEndDate>=Date(MonthsStart(1,Today(),1)) and ContractEndDate<=Date(MonthsEnd(1,Today(),1))"}
I tried to insert the identifier 1 into this part as well, but I couldn't get the syntax right.
Does anyone know how to write it correctly?
Thanks,
Nigel
Try
ContractEndDate={"=Only({1}ContractEndDate)>=Date(MonthsStart(1,Today(),1)) and Only({1}ContractEndDate)<=Date(MonthsEnd(1,Today(),1))"}
edit:
or:
ContractEndDate={">=$(=Date(MonthsStart(1,Today(),1)))<=$(=Date(MonthsEnd(1,Today(),1)))"}
Try
ContractEndDate={"=Only({1}ContractEndDate)>=Date(MonthsStart(1,Today(),1)) and Only({1}ContractEndDate)<=Date(MonthsEnd(1,Today(),1))"}
edit:
or:
ContractEndDate={">=$(=Date(MonthsStart(1,Today(),1)))<=$(=Date(MonthsEnd(1,Today(),1)))"}
Great! That's it. Thanks for the reply swuehl!