Not Match Function_ Problem

[#1]

Hi All,

I want to eliminate data on basis of NOT Match function but i am not getting expected results.

Lets say my code is

LET Var1 = Today()- 1;

Load * from XYZ.QVD

Where Not mact (Date1, '$(Var1)')

But still I am getting Today()- 1 data.

Even if write like:

Load * from XYZ.QVD

Where Not mact (Date1, '11/23/2014').

Still I am getting 11/23/2014 data.

The way I am eliminating With Not match is correct? or is there an another way?

BR ,

Neehu

[Gysbert_Wassenaar · Accepted solution]

Try this:

LET Var1 = num(Today() - 1);

Load * from XYZ.QVD

Where num(Date1) <> $(Var1);

[#3]

HI Gysbet,

WHat if I want to eliminate two dates with two variables?

[Gysbert_Wassenaar]

Use two clauses: Where ...condition1... or ...condition2...

[#5]

Cant I use like this:?

LET Var1 = NUm(Today()- 1);

LET Var2 = Num(Today()- 2);

Load * from XYZ.QVD

Where Not match (Date1, '$(Var1)', '$(Var2)')

[rubenmarin]

Hi, are you sure about the date format stored in xyz.qvd?

If it's not MM/DD/YYYY (maybe Date1 also has the time part?) you can try:

Load * from XYZ.QVD

Where Not match (Date(Date1, 'MM/DD/YYYY'), '11/23/2014').

[Gysbert_Wassenaar]

Maybe. It depends on the format of the Date1 field. You may have to use the date function as Ruben Marin says above.