Hello. I need help with this query. I want it to pull the data from the month prior. Can someone help me with that? I created it using the report tool and grabbed the query from "show query". I do not script. I would like to also take what is updated and add it to other reports I need last month data from.

SELECT wo.WORKORDERID AS "Request ID", sdo.NAME AS "Site", std.ISPENDING AS "Pending Status", std.STATUSNAME AS "Request Status", longtodate(wo.CREATEDTIME) AS "Created Time" FROM WorkOrder wo LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN RequestTypeDefinition rtdef ON wos.REQUESTTYPEID=rtdef.REQUESTTYPEID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  ( ( ( rtdef.NAME = 'Incident' ) AND ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( sdo.NAME = 'AT2380' ) OR ( sdo.NAME = 'AT2380 - Ramsau' ) ) OR ( sdo.NAME = 'AU2450' ) ) OR ( sdo.NAME = 'BR2350' ) ) OR ( sdo.NAME = 'CN0004' ) ) OR ( sdo.NAME = 'CN0020' ) ) OR ( sdo.NAME = 'CN2570' ) ) OR ( sdo.NAME = 'CZ2770' ) ) OR ( sdo.NAME = 'CZ2770 - Vizovice' ) ) OR ( sdo.NAME = 'DE2110' ) ) OR ( sdo.NAME = 'DE2140' ) ) OR ( sdo.NAME = 'DE2140 - Seifersbach' ) ) OR ( sdo.NAME = 'DE2150' ) ) OR ( sdo.NAME = 'DE2200' ) ) OR ( sdo.NAME = 'DE2200 - Koetz' ) ) OR ( sdo.NAME = 'DE2200 Grosskoetz' ) ) OR ( sdo.NAME = 'DE2201' ) ) OR ( sdo.NAME = 'DE2202' ) ) OR ( sdo.NAME = 'DE2202 - Neuenkirchen' ) ) OR ( sdo.NAME = 'DE2203' ) ) OR ( sdo.NAME = 'DE2203 - Ettenbeuren' ) ) OR ( sdo.NAME = 'DE2204' ) ) OR ( sdo.NAME = 'DE2204 - Deffingen' ) ) OR ( sdo.NAME = 'DE2230' ) ) OR ( sdo.NAME = 'DE2292' ) ) OR ( sdo.NAME = 'DE2292- Elsdorf' ) ) OR ( sdo.NAME = 'DE2300' ) ) OR ( sdo.NAME = 'DE2505' ) ) OR ( sdo.NAME = 'DE4130' ) ) OR ( sdo.NAME = 'ES2930' ) ) OR ( sdo.NAME = 'ES2930 - Abadiano' ) ) OR ( sdo.NAME = 'ES2940' ) ) OR ( sdo.NAME = 'ES2940 - Utebo' ) ) OR ( sdo.NAME = 'FR2780' ) ) OR ( sdo.NAME = 'FR2790' ) ) OR ( sdo.NAME = 'FR2790 - Louhans' ) ) OR ( sdo.NAME = 'FR4820' ) ) OR ( sdo.NAME = 'GB2850' ) ) OR ( sdo.NAME = 'GB2850 - Southam' ) ) OR ( sdo.NAME = 'GB2860' ) ) OR ( sdo.NAME = 'IE2855' ) ) OR ( sdo.NAME = 'IE2855 - Athlone' ) ) OR ( sdo.NAME = 'IN4580' ) ) OR ( sdo.NAME = 'IT2500' ) ) OR ( sdo.NAME = 'IT2500 - Vintl' ) ) OR ( sdo.NAME = 'IT2505' ) ) OR ( sdo.NAME = 'IT2510' ) ) OR ( sdo.NAME = 'IT2510 - Trento' ) ) OR ( sdo.NAME = 'IT4560' ) ) OR ( sdo.NAME = 'LT2760' ) ) OR ( sdo.NAME = 'LT2760 - Kaunas' ) ) OR ( sdo.NAME = 'NL2970' ) ) OR ( sdo.NAME = 'NL2970 - Nieuw-Vennep' ) ) OR ( sdo.NAME = 'NL2980' ) ) OR ( sdo.NAME = 'NL2980 - Antwerpen' ) ) OR ( sdo.NAME = 'NL2980 - Hengelo' ) ) OR ( sdo.NAME = 'PL2780' ) ) OR ( sdo.NAME = 'PL2780 - Przezmierowo' ) ) OR ( sdo.NAME = 'RO2620' ) ) OR ( sdo.NAME = 'RO2620 - Sura Mica' ) ) OR ( sdo.NAME = 'RU2800' ) ) OR ( sdo.NAME = 'SE2870' ) ) OR ( sdo.NAME = 'SE2870 - Goeteborg' ) ) OR ( sdo.NAME = 'SE2870 - Gothenburg' ) ) OR ( sdo.NAME = 'TR2340' ) ) OR ( sdo.NAME = 'TR2340 - Istanbul' ) ) OR ( sdo.NAME = 'UK2850' ) ) OR ( sdo.NAME = 'ZA2480' ) ) ) AND ( ( ( longtodate(wo.CREATEDTIME) >= datetolong('1598932800000') ) AND ( ( longtodate(wo.CREATEDTIME) != 0 ) AND ( longtodate(wo.CREATEDTIME) IS NOT NULL ) ) ) AND ( ( longtodate(wo.CREATEDTIME) <= datetolong('1601524799000') ) AND ( ( ( longtodate(wo.CREATEDTIME) != 0 ) AND ( longtodate(wo.CREATEDTIME) IS NOT NULL ) ) AND ( longtodate(wo.CREATEDTIME) != -1 ) ) ) ) )  AND wo.ISPARENT='1' AND wo.IS_CATALOG_TEMPLATE='0'