https://community.sap.com/t5/application-development-and-automation-discussions/sap-hana-filter-expression-errors-using-sql/m-p/545984#M20520 <P></P> <P>Hi everyone, I need help with using the SQL Filter Expression IN SAP HANA. The main goal is to count the number of transactions within the last 24 hours. I was able to join 2 transaction tables but I got stuck in the projection level (Filter). It is giving me an error when I enter the 43200 seconds as a criteria. Can you help me figure out what is wrong? </P> <P><A href="https://answers.sap.com/storage/attachments/85030-untitled.png">untitled.png</A></P> Sun, 19 Nov 2017 13:21:33 GMT Former Member 2017-11-19T13:21:33Z https://community.sap.com/t5/application-development-and-automation-discussions/sap-hana-filter-expression-errors-using-sql/m-p/545984#M20520 <P></P> <P>Hi everyone, I need help with using the SQL Filter Expression IN SAP HANA. The main goal is to count the number of transactions within the last 24 hours. I was able to join 2 transaction tables but I got stuck in the projection level (Filter). It is giving me an error when I enter the 43200 seconds as a criteria. Can you help me figure out what is wrong? </P> <P><A href="https://answers.sap.com/storage/attachments/85030-untitled.png">untitled.png</A></P> Sun, 19 Nov 2017 13:21:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-hana-filter-expression-errors-using-sql/m-p/545984#M20520 Former Member 2017-11-19T13:21:33Z