Set Analysis

[apthansh]

=count(if([Expiration Date Abbrev MDY] > today(),

        if([Expiration Date Abbrev MDY] < AddMonths(today(),2),[ID])))  

trying to put the above in set analysis as below but its not working...

=count({<

           [Expiration Date Abbrev MDY] = {"> Today()"},

            [Expiration Date Abbrev MDY]= {"< AddMonths(Today(),2)"}>}ID)

What am I doing worng ?also my [Expiration Date Abbrev MDY]  is in MM/DD/YY format.

Thanks much.

[sunny_talwar · Accepted solution]

Try this Ansh

=Count({<[Expiration Date Abbrev MDY] = {"$(='>' & Date(Today(), 'MM/DD/YY') & '<' & Date(AddMonths(Today(), 2), 'MM/DD/YY'))"}>} ID)

[Anonymous]

Try this:

count({<

           [Expiration Date Abbrev MDY] = {"<$(=Date(AddMonths(Today(),2), 'MM/DD/YY'))",">$(=Date(Today(), 'MM/DD/YY'))"} >} ID)

[Frank_Hartmann]

try this:

count({<[Expiration Date Abbrev MDY]  = {">$(=Date(Today(),'MM/DD/YY'))<$(=Addmonth(Today(),2),'MM/DD/YY'))"}>} ID)

hope this helps

[apthansh]

Thanks much.That worked.