Look ML

[Tusharr_Batra]

I do not get any error while passing a date range to ‘rev_rec_date’ in SQL runner, but getting an error ‘:invalid value for "YYYY" in source string’, when I do the same while defining a view. Attached are the shots. Please help

[Dawid]

Hi @Tusharr_Batra 

It’s not quite clear what’s causing this error. How you looked at SQL generated after you define a view? Is it any different?

[Tusharr_Batra]

I am Union - ing this query with another while defining the view

[leobardor]

Hi Tusharr.

Oh I had the same error message in another project hehe . It is not looker related.

In the line number #63, you will need to include “to_date” function for searching the date “2021-01-01”.

You may came from sql server where this syntax  works, but unfortunately it does not in any SQL solution.

Hope this helps!

Best regards,

Leo

[Tusharr_Batra]

Thanks for the revert @leobardor , I tried that way as well but it did not work, eventually I had to it other way by creating a table in DB