Add Last Month and This Month to SWQL graphical query builder quick picks

Can SW add Last Month and This month to the SWQL graphical query builder quickpicks so I dont have to spend hours trying to figure out how to add this to my queries? I am not great at scripting and for KPI widgets I am only interested in this months or last months data, generally not the last x days data.

Currently the query returns for last 30 days:

 WHERE (i.DateTime BETWEEN '2022-06-08T02:29:01Z' AND '2022-07-08T02:29:01Z')


how do i change this to

WHERE (i.DateTime = LAST MONTH) or
WHERE (i.DateTime = THIS MONTH)
 

thanks

Matt

Parents Reply Children
No Data