topic Re: Not equal <> is not working at script level varaible in App Development

Not equal <> is not working at script level varaible

Abhi999 — Tue, 27 Oct 2020 00:27:06 GMT

below expression is not working at script level.

LET vWeek_End_Not <> date(max(week_ending)-7,'DD/MM/YYYY')

Thiago_Justen_ — Tue, 27 Oct 2020 01:34:34 GMT

Hello,

What about you change things like this?

LET vWeek_End_Not = date(max(week_ending)-7,'DD/MM/YYYY');

Then you put it into a where clause, for instance:

Load

Your_Fields

From your_db where week_ending <> '$(vWeek_End_Not)';

Try this out and tell us what happened.

Regards

MayilVahanan — Tue, 27 Oct 2020 06:27:32 GMT

LET vWeek_End_Not <> date(max(week_ending)-7,'DD/MM/YYYY')

Max function not work in "Let" statement.

You need to try like below

Load max(week_ending) as MaxWeek resident yoursourcetable;

Let vWeek_End_Not = Date(Peek('MaxWeek')-7,'DD/MM/YYYY');

Load

* from your_Sourcetable where week_ending <> '$(vWeek_End_Not)';

Hope it helps