Need help in the query builder.
| dbxquery connection="ITDW" shortnames=true query="SELECT
[Incident_Number],
[Assignee],
[Last_Modified_By],
[Customer],
[Customer_Site_Group],
[Customer_Site],
[Summary],
[Notes],
[Priority],
[Assigned_Support_Group],
[Status],
[Status_Reason],
[Resolution],
[Reported_Date],
[Last_Resolved_Date],
[Last_Modified_Date],
[Owner_Group],
[Submit_Date]
FROM [shared].[ITSM_INC_MAIN] INC
WHERE [Submit_Date] BETWEEN DATEADD(D,-3,GETDATE()) AND GETDATE()
AND
[Summary] like '%%' "
I am facing challenge in getting the date changed all time for a search.
Submit_Date
2020-04-04 11:35:51.0
2020-04-04 11:35:57.0
2020-04-04 11:36:13.0
2020-04-04 11:37:22.0
here is how Submit date format comes.
Also below is the line where am facing challenge in providing a defined time.
WHERE [Submit_Date] BETWEEN DATEADD(D,-3,GETDATE()) AND GETDATE()
please help me in editing this line
any suggestions please
1) Are you trying to get all the data for the last 3 days, or are you trying to get data since a particualr time, or what?
2) what is the underlying database, SQL Server or Oracle or what? Time functions are often unique to each implementation of SQL.