QlikSense Where Condition Problem

[#1]

Hi all,

I have this calculated dimension:

(if(len(CloseDate__c)=0, date(UnofficialCloseDate__c,'YYYY-MM-DD'),date( CloseDate__c,'YYYY-MM-DD'))) as date_fiscal_year

I need to insert it in the where conditon between two time ranges in the load script and  I don't know how they work together.

How can I fix the problem?

Thanks a lot.

Bye bye