Report between 2 specific dates/times
HI Guys,
Have tried to use the below end but of my query to look for requests specifically created between 01-04-2020 10:00:00 and 02-04-2020 09:59:59
AND ((("wo"."CREATEDTIME" >= datetolong('2020-04-01 10:00:00')) AND (("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL))) AND (("wo"."CREATEDTIME" <= datetolong('2020-04-02 09:59:59')) AND ((("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL)) AND ("wo"."CREATEDTIME" != -1))))) AND wo.ISPARENT='1' ORDER BY 7
But its throwing the created time result back in a funny 13 digit format.
Is there a way I can tweak this query to return tickets created in this specific time frame.
This is just an example by the way I would like to create further reports in different specified timez too so if anyonce can explain the theory behind the formatting it would be much obliged :)
Best Regards