I am running the below query. I would like to make this query more dynamic, however, so I would like to use the 2nd query instead.

```
SELECT  X
FROM    Y
WHERE   Z
and  file_created_date  = '12/18/2016'

SELECT  X
FROM    Y
WHERE   Z
and  file_created_date  = SELECT date(GETDATE()-2)

```

The 2nd query returns an error around the Select of 

```
SELECT date(GETDATE()-2)

```