To find if a given date lies in the last week of the month

Question

Hi, 
 I need to find out if a given date is in the last week of the month. For example 27th of March 2023 is in the last week of the March month. How can I achieve this? Please give me the suggestions. 
 Thanks and Regards, 
 Brinda Sateesh

Sanchit Gupta (Xebia) · Accepted Answer

This should work. 
 a!localVariables(
 local!monthEndDay: weekday(eomonth(ri!date, 0), 3),
 local!endWeekStartDate: eomonth(ri!date, 0) - local!monthEndDay,
 or(ri!date >= local!endWeekStartDate)
)

To find if a given date lies in the last week of the month

Top Replies