set analysis dates comparison

[#1]

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

[giakoum]

Looks generally correct. Try eliminating the = sign and combine them into one :

Count({$<[Date CA]={'>=$(startdate)<=$(enddate)'} >   } distinct [Nom Client])

[ThornOfCrowns]

An example:

{$<Year={">=2006 <=2010"}>}

will return the results for years 2006 to 2010 inclusive

[#4 · Accepted solution]

hi

try this

=count( {$ < [Date CA]={ '>=$(=startdate) <= $(=enddate)' } >   } distinct [Nom Client])

[#5]

thanks for all