https://community.qlik.com/t5/Connectivity-Data-Prep/max-date-in-qlikview/m-p/1776269#M5701 <P>I have dates&nbsp;</P><P>Dec 2020, Jan 2021, Feb 2021 till Nov 2021</P><P>when i select Dec2020.. then in text object date should be displayed as '-' instead of Nov 2020...</P><P>when I select date Dec 2020 text object display Nov 2020..&nbsp;</P><P>i try this&nbsp;</P><LI-CODE lang="markup">=MonthName(vMaxMonth-1)</LI-CODE><P>&nbsp;</P><P>and vmaxmonth is</P><LI-CODE lang="markup">=(MonthName(max((Date_Email))))</LI-CODE><P>&nbsp;</P><P>how I show '-' instead of Nov 2020 ?</P><P>&nbsp;</P> Thu, 21 Jan 2021 11:06:22 GMT capriconuser 2021-01-21T11:06:22Z https://community.qlik.com/t5/Connectivity-Data-Prep/max-date-in-qlikview/m-p/1776269#M5701 <P>I have dates&nbsp;</P><P>Dec 2020, Jan 2021, Feb 2021 till Nov 2021</P><P>when i select Dec2020.. then in text object date should be displayed as '-' instead of Nov 2020...</P><P>when I select date Dec 2020 text object display Nov 2020..&nbsp;</P><P>i try this&nbsp;</P><LI-CODE lang="markup">=MonthName(vMaxMonth-1)</LI-CODE><P>&nbsp;</P><P>and vmaxmonth is</P><LI-CODE lang="markup">=(MonthName(max((Date_Email))))</LI-CODE><P>&nbsp;</P><P>how I show '-' instead of Nov 2020 ?</P><P>&nbsp;</P> Thu, 21 Jan 2021 11:06:22 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/max-date-in-qlikview/m-p/1776269#M5701 capriconuser 2021-01-21T11:06:22Z https://community.qlik.com/t5/Connectivity-Data-Prep/max-date-in-qlikview/m-p/1776458#M5709 <P>Perhaps this?</P><P><STRONG>If(GetSelectedCount(Date_Email)&gt;0, MonthName(vMaxMonth-1), '-')</STRONG></P> Thu, 21 Jan 2021 18:48:15 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/max-date-in-qlikview/m-p/1776458#M5709 Anil_Babu_Samineni 2021-01-21T18:48:15Z