I have a DB querry, need a help in date filter.
| dbxquery connection="ITDW" shortnames=true query="SELECT
GETDATE() as 'CurrentTime',
PPL.Region as 'Customer_Region',
PPL.Site_Group as 'Customer_Site_Group',
PPL.Site as 'Customer_Site',
FROM [shared].[ITSM_INC_MAIN] INC
LEFT OUTER JOIN [shared].[ITSM_CMDB_People_Main] PPL
INC.Customer_ID = PPL.Person_ID
WHERE (([Assigned_Support_Group] = 'Ops-WAN'))
AND [Submit_Date] BETWEEN DATEADD(D,-700,GETDATE()) AND GETDATE()"
I want some data which is old , filter only data that is of 2019, but when i search for more than 300 days. its not showing the accurate data.
how can i add a specific year or between date in the code.