topic check if an expire date is within 18 months from now in Data & Schema Discussions https://community.incorta.com/t5/data-schema-discussions/check-if-an-expire-date-is-within-18-months-from-now/m-p/6993#M594 <P>Is this expression supposed to work? SO that the count of such "matches" can be aggregated in an insight to report on:</P><DIV><DIV><SPAN>case(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>(addMonths(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>$currentDate</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>18</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>)</SPAN> <SPAN>&gt;</SPAN> <SPAN>WPR_test.Lease.Expire_Date</SPAN><SPAN>)</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>1</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>0</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV> Mon, 13 Apr 2026 04:12:12 GMT Samiran 2026-04-13T04:12:12Z check if an expire date is within 18 months from now https://community.incorta.com/t5/data-schema-discussions/check-if-an-expire-date-is-within-18-months-from-now/m-p/6993#M594 <P>Is this expression supposed to work? SO that the count of such "matches" can be aggregated in an insight to report on:</P><DIV><DIV><SPAN>case(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>(addMonths(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>$currentDate</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>18</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>)</SPAN> <SPAN>&gt;</SPAN> <SPAN>WPR_test.Lease.Expire_Date</SPAN><SPAN>)</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>1</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>0</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV> Mon, 13 Apr 2026 04:12:12 GMT https://community.incorta.com/t5/data-schema-discussions/check-if-an-expire-date-is-within-18-months-from-now/m-p/6993#M594 Samiran 2026-04-13T04:12:12Z Re: check if an expire date is within 18 months from now https://community.incorta.com/t5/data-schema-discussions/check-if-an-expire-date-is-within-18-months-from-now/m-p/6994#M595 <DIV><DIV><SPAN>case(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>(addMonths(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>$currentDate</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>18</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>)</SPAN> <SPAN>&gt;</SPAN> <SPAN>WPR_test.Lease.Expire_Date</SPAN><SPAN>)</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>1</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>0</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV> Mon, 13 Apr 2026 04:11:28 GMT https://community.incorta.com/t5/data-schema-discussions/check-if-an-expire-date-is-within-18-months-from-now/m-p/6994#M595 Samiran 2026-04-13T04:11:28Z Re: check if an expire date is within 18 months from now https://community.incorta.com/t5/data-schema-discussions/check-if-an-expire-date-is-within-18-months-from-now/m-p/6995#M596 <P>Formula looks good.</P> <P>I will recommend to add this as a formula column (flag with 0 or 1 value)) in physical table and then use aggregation on this flag to show in insight in dashboard.</P> Tue, 14 Apr 2026 14:17:47 GMT https://community.incorta.com/t5/data-schema-discussions/check-if-an-expire-date-is-within-18-months-from-now/m-p/6995#M596 anurag 2026-04-14T14:17:47Z