Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hallo,
I need something like this in form of set analyse:
count customer where
( record.startdate >= vStartDate and ( record.enddate is null or record.enddate >= vEndDate ))
Thanks in advance
Heinz
count({$ <record.startdate={'>=$(vStartDate)'}, record.enddate={'>=$(vEndDate)'}>} customer)
hope it helps
count({$ <record.startdate={'>=$(vStartDate)'}, record.enddate={'>=$(vEndDate)'}>} customer)
hope it helps
Hi Heinz
the syntax is weird but...
count({<record.startdate ={">=$(vStartDate) >=$(vEndDate)">} customer)
best regards
Chris
Hi,
Try this.
Count({<record.startdate = {'>=$(vStartDate) <=$(vEndDate)'}>} customer)