Currently I am looking for a way to avoid hard coding date values for select queries I seek to automate. Ideally my queries will run daily on a report server, so I want the day to change automatically but I would like to specify the time values the date function uses. Example of hard coded value is below. 

```
SELECT * 
FROM [xxxx].[dbo].[LOADS]
WHERE NOT STATUS = '' AND LOCATION LIKE 'C0%' AND 
EDITDATE <= '2018-01-19 00:00:00.000'  
ORDER BY EDITDATE DESC 

```

I know I can use this SYSDATETIME function to grab current date and time. This is helpful but I want to specify the time values. Any thoughts or assistance would be greatly appreciated. The main idea is to have the query run by itself automated so the date will change based on T-SQL syntax but I would like to specify the time values. 

```
    SELECT * 
FROM [xxxx].[dbo].[LOADS]
WHERE NOT STATUS = '' AND LOCATION LIKE 'C0%' AND EDITDATE <= SYSDATETIME()  
ORDER BY EDITDATE DESC 

```