The first two queries here works fine:

```
SELECT * FROM sys_calendar.calendar
WHERE calendar_date BETWEEN CAST('2012-06-01' AS DATE) - 365 
                        AND CAST('2013-06-01' AS DATE) - 1;

SELECT * FROM sys_calendar.calendar
WHERE calendar_date IN ('2012-06-01', '2013-06-03');

```

However, the next two queries throw the error 

> 
> SELECT Failed. [3706] Syntax error: expected something between ')' and ','.
> 
> 
> 

It appears that the `CAST` is throwing off the IN clause, but I don't understand why. What is going on here?

```
SELECT * FROM sys_calendar.calendar
WHERE calendar_date IN (CAST('2012-06-01' AS DATE) 
                      , CAST('2013-06-03' AS DATE));

SELECT * FROM sys_calendar.calendar
WHERE calendar_date IN (CAST('2012-06-01' AS DATE) - 365
                      , CAST('2013-06-01' AS DATE) - 1);

```