select * from transactions where order-date is between 01/01/2018 12:00:00 to 01/02/2019 12:00:02
Hi @Basam.Nath
Please make a note that the supported timestamp format is:
yyyy-MM-dd'T'HH:mm:ss.SSSZZ
About Orderdate, it appears to me that Orderdate is collected as a "String" and as you know, date manipulation does not work on string values.