Question: I have a problem with certain assets on heroku. (local environment is working fine)
The assets are in the pipeline. If I execute in the heroku rails console:

```
helper.asset_path("typicons.woff")
helper.asset_path("backgrounds/1.jpg")

```

I get the following response:

```
/assets/typicons-c2430aad2b6a33948dc064cfaee8ad65ff9e3ca439834f3aaa84abec3d10dea8.woff
/assets/backgrounds/1-c2098ff7e7fbb89b2d18e9cd9089f712f2b837265d1d2e4182c36c23392760c6.jpg

```

So I assume that the assets are in the heroku asset pipeline. As well by opening the url directly with the digest in it, I receive the file. 

However if I try to reference the files in css or javascript like this:

```
  $('.top-content').backstretch("/assets/backgrounds/1.jpg");

```

The file does not load. As well opening /assets/backgrounds/1.jpg directly does not work. Referencing assets from .rb or .erb files works.

Please can someone tell me, what kind of config I have to change, so the URLs for assets work as well without the digest?

Thank you!

Answer: 
```
AND DateFromParts(ym.year, ym.month, 1) BETWEEN @startDate AND @endDate

```

EDIT: For old versions of SQL:

```
SELECT CAST(CAST(ym.year*10000+ym.month*100+1 AS CHAR(8)) AS DATETIME)

```
Try this :

```
CAST(CAST(ym.year AS varchar) + '-' + CAST(ym.month AS varchar) + '-01'  AS DATETIME)

```