Using this start expression to generate a monthly report at the beginning of each month for collection records for the previous month. Not sure if it is correct. Would anyone be able to confirm or correct?
<<Start:ORDERBY(SELECT(Collection Event[Collection Key],EOMONTH(DATE([Timestamp]),0)=EOMONTH(TODAY(),-1)),[Timestamp],FALSE)>><<[TIMESTAMP]>>
Had been using but I’ve had some inconsistent results.