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)