Week variable not working

nkosinde13 — Wed, 25 Nov 2020 16:16:04 GMT

I created this variable on the script:

LET vLastSaturday = date(date#(weekstart(today()),'yyyy/mm/dd'),'yyyy-mm-dd');

Then on my data, I want to pull only sales that are before the variable date, so my where clause looks like this:

where cast( [POLICY_CREATE_DATE] as date) < $(vLastSaturday)

The original POLICY_CREATE_DATE format is datetime so I'm formating it to yyyy-mm-dd so that it's the same as my variable.

But when I reload the data, it gives me Operand type clash error. Please see attached screenshot and assist.

Thanks

Re: Week variable not working

jonathandienst — Tue, 04 Jun 2019 12:39:46 GMT

You need quotes:

where cast( [POLICY_CREATE_DATE] as date) < '$(vLastSaturday)';

nkosinde13 — Thu, 06 Jun 2019 10:07:24 GMT

Thank you, your solution worked.