Skip to Content
0
Nov 29, 2022 at 07:45 AM

Between does not work

62 Views

My system config is NW FOR S4HANA ONPREMISE 1709 07 (10/2020) sap.com NW 7.52 FOR S/4HANA 1709

Aim to get count of records for 2018, 2019, 2020, 2021 and 2022 year set and below is my query

In back end posting date results are in yyyy-mm-dd format only.

SELECT

*

FROM

ZCTD_GL_ACCOUNT_01

WHERE

POSTINGDATE BETWEEN '2022-01-01' AND '2022-12-31'

Where am I going wrong ?

Need your help