This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

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