Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I would like to count all the policies which have an expiry date in the current month or proceeding 2 months. Here is what I have come up with but it does not seem to be working. Can anyone see what I have done wrong please?
Count({$<[Expiry Date]={"$(='>=' & monthstart(Today()) & '<=' & monthend(addmonths(today(),2)))"}> } distinct[Policy Number])
Many thanks
=Sum({$<[Expiry Date]={">=$(=MonthStart(Today()))<$(=monthend(Today(),2))"}>}distinct[Policy Number])
make sure ur Expire date format is same as =MonthStart(Today())
try this