Can someone help with this please?

[#1]

Hi everyone,

I have the following script that pulls financial data from a QVD I've already built, I need to strip out any value that's been loaded against the current month.

LOAD SchemeNo,

           MonthYear,

           FUMValue

FROM

UnisureFUM.qvd (qvd);

Basically I'm trying to load everything prior to Feb-2016 (as this is the current month)

Any suggestions as I'm trying a Where clause with a variable I've created and can't get it to work...

[sunny_talwar]

May be this:

LOAD SchemeNo,

          MonthYear,

          FUMValue

FROM

UnisureFUM.qvd (qvd)

Where Num(MonthYear) < Num(MonthStart(Today()));

[avinashelite]

check whether you field and variable date format are same and then use the where clause this should solve your issue.

Try like this :

Let vCurrentmonth=MonthStart(Today());

LOAD SchemeNo,

          MonthYear,

          FUMValue

FROM

UnisureFUM.qvd (qvd)

where MonthYear< $(vCurrentmonth)

or

where MonthYear< (vCurrentmonth)

NOTE: Make sure your variable(vCurrentmonth) and the field(MonthYear) are in same format

[Anonymous]

may be this?

LOAD SchemeNo,

           MonthYear,

           FUMValue

FROM

UnisureFUM.qvd (qvd) where Num(MonthYear)<>Num(MonthStart(Today()));