Not able to check the condition

[#1]

Hi Friends,

I have declared a variable like this 

LET vAccountingPeriod=Date#(ADDMONTHS(YEARSTART(Now()),-12),'YYYYMM');

Which is equal to 201401.

and loaded the data like

Load * from table

where Date#([Acct-PrdOO],'YYYYMM')>Date#($(vAccountingPeriod),'YYYYMM');

But I am getting all the data and  the check condition is failing.

Please let me know the error in the code.....

Thanks

[#2]

As you have already set the format in the variable, you should be able to just use

where Date#([Acct-PrdOO],'YYYYMM')>'$(vAccountingPeriod)';

hope that helps

Joe

[Gysbert_Wassenaar · Accepted solution]

Try:

LET vAccountingPeriod= floor(ADDMONTHS(YEARSTART(Now()),-12));

Load * from table

where floor(Date#([Acct-PrdOO],'YYYYMM')) > $(vAccountingPeriod);

[#4]

Hi Gysbert

Its working!!! Could I know the reason please

[Gysbert_Wassenaar]

When using dates in comparisons it's often wise to use only the numeric value and not mess around with the different format string representations of the dates.