Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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.
Try this Ansh
=Count({<[Expiration Date Abbrev MDY] = {"$(='>' & Date(Today(), 'MM/DD/YY') & '<' & Date(AddMonths(Today(), 2), 'MM/DD/YY'))"}>} ID)
Try this Ansh
=Count({<[Expiration Date Abbrev MDY] = {"$(='>' & Date(Today(), 'MM/DD/YY') & '<' & Date(AddMonths(Today(), 2), 'MM/DD/YY'))"}>} ID)
Try this:
count({<
[Expiration Date Abbrev MDY] = {"<$(=Date(AddMonths(Today(),2), 'MM/DD/YY'))",">$(=Date(Today(), 'MM/DD/YY'))"} >} ID)
try this:
count({<[Expiration Date Abbrev MDY] = {">$(=Date(Today(),'MM/DD/YY'))<$(=Addmonth(Today(),2),'MM/DD/YY'))"}>} ID)
hope this helps
Thanks much.That worked.