Show first day of the last week of the month

[Anonymous]

Hi All, 

I need help from you dear gurus. 

I need to return the first day of the last week of the month in the query. This is so that I can filter out only the data that I need. 

For e.g., if its 20/09 today then I would need to return 30th of August (Monday which is the first day of the last week of the month) 

Thanks a bunch for all your wisdom. 

[amitchandak · Accepted solution]

@Anonymous , You can get like

Last Month last weekWeek Start date =
var _dt = eomonth(today() ,-1)
return
_dt+-1*WEEKDAY(_dt,2)+1