Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi every body ,
i'm trying to obtain clients commands between two dates and this is my expression
=count( {$ < [Date CA]={'>=$(=startdate)'}, [Date CA]={'<=$(=enddate)'} > } distinct [Nom Client])
startdate and enddate are variables
hi
try this
=count( {$ < [Date CA]={ '>=$(=startdate) <= $(=enddate)' } > } distinct [Nom Client])
Looks generally correct. Try eliminating the = sign and combine them into one :
Count({$<[Date CA]={'>=$(startdate)<=$(enddate)'} > } distinct [Nom Client])
An example:
{$<Year={">=2006 <=2010"}>}
will return the results for years 2006 to 2010 inclusive
hi
try this
=count( {$ < [Date CA]={ '>=$(=startdate) <= $(=enddate)' } > } distinct [Nom Client])
thanks for all