Current Month Criteria on BAQ

Hi all,

Having a moment where I can’t quite figure out the logic of something I’m trying to do. I’m trying to write a BAQ to display PO details for the current month only.

Idea being that at the end of every week this BAQ will fire through a BAQ Report to send an email with essentially week to date PO spend, which by month end will be a month to date. Then the following month would automatically only show that month, etc.

Nice and automated, no manual intervention required.

What I’m struggling to work out is how can I set the criteria on the BAQ for current month only, without having to manually input it, or manipulate every month end?

You could add BAQ Constant criteria (FirstDayOfMonth, LastDayOfMonth from what i recall


Thank you, that’s the missing piece I couldn’t suss!