topic Calendar expression to flag Date as occurring in last week of month in App Development https://community.qlik.com/t5/App-Development/Calendar-expression-to-flag-Date-as-occurring-in-last-week-of/m-p/1893870#M73727 <P>The Week() funtion returns the week number in the year. I need to classify transaction dates as occurring in last week of each month.</P> <P>&nbsp;</P> <P>Thanks</P> Wed, 16 Feb 2022 16:59:04 GMT nickedw0 2022-02-16T16:59:04Z Calendar expression to flag Date as occurring in last week of month https://community.qlik.com/t5/App-Development/Calendar-expression-to-flag-Date-as-occurring-in-last-week-of/m-p/1893870#M73727 <P>The Week() funtion returns the week number in the year. I need to classify transaction dates as occurring in last week of each month.</P> <P>&nbsp;</P> <P>Thanks</P> Wed, 16 Feb 2022 16:59:04 GMT https://community.qlik.com/t5/App-Development/Calendar-expression-to-flag-Date-as-occurring-in-last-week-of/m-p/1893870#M73727 nickedw0 2022-02-16T16:59:04Z Re: Calendar expression to flag Date as occurring in last week of month https://community.qlik.com/t5/App-Development/Calendar-expression-to-flag-Date-as-occurring-in-last-week-of/m-p/1893879#M73728 <P>Perhaps</P><P>Week(Date)=Week(MonthEnd(Date)) as IsInLastWeekOfMonth</P> Wed, 16 Feb 2022 17:16:21 GMT https://community.qlik.com/t5/App-Development/Calendar-expression-to-flag-Date-as-occurring-in-last-week-of/m-p/1893879#M73728 hic 2022-02-16T17:16:21Z